Entity Framework: Generated SQL - cannot find data type datetime2

Question

So we migrated dev sql server to 2008.

Our UAT sql server is still 2005.

i had to regenerate my entity framework model for some other reasons, and upon deploying my work to UAT i noticed this error:

cannot find data type datetime2

I profiled the database, and noticed that Entity Framework generated the input parameter as datetime2!

N'@p__linq__0 datetime2(7)',@p__linq__0='9999-12-31 00:00:00'

this executes fine in dev, because datetime2 is a type there. but fails when deployed to environment with 2005.

Is this some sort of known type? Why is entity framework not using regular datetime, and how can i make it cross environment compatible?

perhaps this is not 2008 upgrade related.. but it wasn't an issue before the upgrade and this code has not changed.

possible duplicate of LINQ to Entities produces query containing datetime2 on SQL 2005 Express — Will A
– Will A, Commented May 19, 2011 at 23:13

Community · Accepted Answer · 2017-05-23 12:26:57Z

3

Take a look at this 'bug' on MS Connect - the workarounds seem to supply a fairly straightforward fix.

Also covered here.

CommunityBot

11 silver badge

answered May 19, 2011 at 23:08

Will A

25k5 gold badges54 silver badges61 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

MS Connect has been retired, the stackoverflow link looks fine