Ask a questionAsk a question
 

AnswerEF issue with Time Type (SQL Server 2008)

  • Thursday, October 29, 2009 11:22 AMMadden13 Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    Hi everybody

    I have a problem with my ADO.NET Entity Data Model.

    My model contains a table with a column of type "time"

    When my ADO.NET Data Service initializes the "ObjectContextServiceProvider", it throws an Exception "System.Collections.Generic.KeyNotFoundException"

    thought that the SQL Server 2008 type "time" was supported by The Entity Framework.

    Is there any way of solving this problem?

    Thanks

    Madden


    • Moved byYichun_FengMSFTMonday, November 02, 2009 6:15 AMData Services Issue (From:ADO.NET Entity Framework and LINQ to Entities)
    •  

Answers

  • Thursday, October 29, 2009 1:51 PMMadden13 Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     Answer
    Ok I found where is my problem. 

    It's not an issue with ADO.NET Entity Data Model...

    SQL Server 2008 Time type is supported by  Entity Framework but not supported by ADO.NET Data Service.

All Replies

  • Thursday, October 29, 2009 1:51 PMMadden13 Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     Answer
    Ok I found where is my problem. 

    It's not an issue with ADO.NET Entity Data Model...

    SQL Server 2008 Time type is supported by  Entity Framework but not supported by ADO.NET Data Service.
  • Monday, November 02, 2009 6:14 AMYichun_FengMSFTUsers MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    Hi Madden,

    I'm moving this thread to Data Service forum since your issue is more related to that.
    You can get better answer in that forum.


    Thanks!
    Yichun Feng

    Please remember to mark the replies as answers if they help and unmark them if they provide no help.
    Welcome to the All-In-One Code Framework! If you have any feedback, please tell us.