‘datetime2’ error when using entity framework in VS 2010 .net 4.0

by

Entity framework handles all the dates as a Datetime2, so, if your fields in the database are Datetime, this could be a problem.
We had the same problem here, and from what we found, populating all the date fields and changing the datatype, are the most commom solutions

More Related Contents:

  1. summing values of a column based on id [closed]
  2. MSSQL Error ‘The underlying provider failed on Open’
  3. Conversion of a datetime2 data type to a datetime data type results out-of-range value
  4. Adding multiple parameterized variables to a database in c#
  5. Getting data from stored procedure with Entity Framework
  6. Entity framework very slow to load for first time after every compilation
  7. How to connect to database from Unity
  8. Writing Recursive CTE using Entity Framework Fluent syntax or Inline syntax
  9. How can I lock a table on read, using Entity Framework?
  10. Entity Framework 6 GUID as primary key: Cannot insert the value NULL into column ‘Id’, table ‘FileStore’; column does not allow nulls
  11. SQL WHERE clause matching values with trailing spaces
  12. Mapping composite keys using EF code first
  13. SqlDataSourceEnumerator.Instance.GetDataSources() does not locate local SQL server 2008 instance
  14. SqlParameter does not allows Table name – other options without sql injection attack?
  15. EF 6 – How to correctly perform parallel queries
  16. Entity-framework code is slow when using Include() many times
  17. Delete a single record from Entity Framework?
  18. Optimistic concurrency: IsConcurrencyToken and RowVersion
  19. get date part only from datetime value using entity framework
  20. Entity Framework 6 transaction rollback
  21. The LINQ expression could not be translated and will be evaluated locally
  22. Dynamic query with OR conditions in Entity Framework
  23. Entity Framework | Sequence contains more than one matching element
  24. Keyword Not Supported: Metadata
  25. Why is EF generating SQL queries with unnecessary null-checks?
  26. How to Specify Primary Key Name in EF-Code-First
  27. How to Identify the primary key duplication from a SQL Server 2008 error code?
  28. Should the order of LINQ query clauses affect Entity Framework performance?
  29. Watch for a table new records in sql database
  30. Bulk-deleting in LINQ to Entities

Leave a Comment