Daily Archives: February 23, 2008

Will LINQ to Entities and Entity SQL get SQL Server’s new data types, too?

One of the points Faisal made in his post Coming soon to LINQ to SQL is that there will be support for the new types in SQL Server 2008 in the next release (SP1?).

It made me wonder if the LINQ to Entities and Entity SQL will gain these before Entity Framework is released?

One of the benefits of Entity SQL is that it in addition to the canonical functions that it supports (for all providers), it also support provider specific functions and provider primitive types. So for Entity SQL it’s a matter of getting the types into the data provider.

For LINQ to Entities, they also need to get it into the Entity Framework APIs. Perhaps they are doing that along with the LINQ to SQL update?

Note: Dont’ miss Danny Simmons’ reply in the comments!