The EDM function 'CreateTime' is not supported on versions of SQL Server earlier than SQL Server 2008.

Question

Hi, 

I'm using  .Net 4.5 /c# /sql server 2008 R2 /EF. CreateTime function giving error "The EDM function 'CreateTime' is not supported on versions of SQL Server earlier than SQL Server 2008." where as other canonical functions are working fine.

Is this a bug or any resolution available? 

Thanks in advance for the reply.

Regards

Shubhra Bakshi

Answer 1

Are you using an EDMX. What does the first few lines of it look like?

---

Please mark as answer, if this was it. Visit my SQL Server Compact blog http://erikej.blogspot.com

Answer 2

I'm using string str = ((System.Data.EntityClient.EntityCommand)com).ToTraceString(); to validate the command.

Here itself the exception occurs.

where as com.CommandText is something like "select CreateTime(10,10,10) from table1".

Answer 3

You did not answer any of my questions... 

---

Please mark as answer, if this was it. Visit my SQL Server Compact blog http://erikej.blogspot.com

Answer 4

No, not using EDMX, instead generating files .csdl, .msl, and .ssdl manually.

Answer 5

OK, so what is the value of ProviderManifestToken in your ssdl?

---

Please mark as answer, if this was it. Visit my SQL Server Compact blog http://erikej.blogspot.com

Answer 6

 ProviderManifestToken="Ora92"

Answer 7

Oracle!

It should be "2008" and  Provider value in SSDL is ?

---

Please mark as answer, if this was it. Visit my SQL Server Compact blog http://erikej.blogspot.com

Answer 8

 For SQL connection was ProviderManifestToken=2005. Changed it to 2008 and it worked.

, Ora92 was for oracle connection.

Thanks a lot for the guidence.

Regards

Shubhra