title: SQL Server backward compatibility in Entity Framework?
body: <p>Is there any backward compatibility in the entity framework between SQL Server 2008 and 2005?</p>
  
  <p>It seems the framework forces you to use the same provider for all the .edmx files in a solution. </p>
  
  <p>If you use the 2008 provider, data types like DateTime2 and functions like SysDateTime that are emitted by the framework to the underlying SQL query make it useless to use them against a SQL 2005 Server.</p>
  
  <p>Any way around this?</p>