Answered by:
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
Friday, July 4, 2014 6:47 AM
Answers
-
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
- Marked as answer by Shubhra Bakshi Friday, July 4, 2014 11:59 AM
Friday, July 4, 2014 11:25 AM
All replies
-
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
Friday, July 4, 2014 7:00 AM -
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".
- Edited by Shubhra Bakshi Friday, July 4, 2014 10:24 AM
Friday, July 4, 2014 10:22 AM -
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
Friday, July 4, 2014 10:38 AM -
No, not using EDMX, instead generating files .csdl, .msl, and .ssdl manually.Friday, July 4, 2014 11:08 AM
-
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
Friday, July 4, 2014 11:15 AM -
ProviderManifestToken="Ora92"Friday, July 4, 2014 11:19 AM
-
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
- Marked as answer by Shubhra Bakshi Friday, July 4, 2014 11:59 AM
Friday, July 4, 2014 11:25 AM -
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
Friday, July 4, 2014 11:55 AM