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

  • Question

  • Hi All,

    We have a solution made in .net 4/c#/sql server/EF. It is mostly tested on SQL Server 2008 though we also tried it on SQL Server 2005. Suddenly on customer site where they use SQL Server 2005 we got an exception. The inner exception tells: The EDM function 'CreateTime' is not supported on versions of SQL Server earlier than SQL Server 2008.

    I could find nothing about this kind of error. Something about data binding in EF?

    Can someone put light on it?

    Thanks!
    Artem Kliatchkine

    • Moved by Vicky SongMicrosoft employee Friday, November 16, 2012 2:55 AM (From:Visual Studio Database Development Tools (Formerly "Database Edition Forum"))
    Thursday, November 15, 2012 1:01 PM

Answers

  • Hi,

    Likely because it returns a Time datatype which is new in SQL Server 2008. Not sure what is the client side context (for which query does it fails ?).

    IMO it's best to develop against the lower version you support and to test on later version (which are usually compatible) than the other way round (else it's easy to use new features unintentionaly).


    Please always mark whatever response solved your issue so that the thread is properly marked as "Answered".


    Friday, November 16, 2012 10:10 AM

All replies

  • Hi Artem,

    I am moving your issue to the ADO.NET Entity Framework and LINQ to Entities forum so that you can get better support.

    Thanks.


    Vicky Song [MSFT]
    MSDN Community Support | Feedback to us

    Friday, November 16, 2012 2:54 AM
  • Hi,

    Likely because it returns a Time datatype which is new in SQL Server 2008. Not sure what is the client side context (for which query does it fails ?).

    IMO it's best to develop against the lower version you support and to test on later version (which are usually compatible) than the other way round (else it's easy to use new features unintentionaly).


    Please always mark whatever response solved your issue so that the thread is properly marked as "Answered".


    Friday, November 16, 2012 10:10 AM