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

  • 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

    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".


    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

    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