Using sql date data type and EF4

entity-framework sql-server-2008 entity-framework-4
James Alexander picture James Alexander · Dec 16, 2009 · Viewed 21.2k times · Source

I have a table w/ a sql date data type. When I look at the EDM markup, the storage element reflects this. The conceptual entity has a data type of DateTime (there doesn't appear to be a Date data type). When I call save changes and have a DateTime instance associated w/ the entity I want to persist, I get the following error:

The conversion of a datetime2 data type to a datetime data type resulted in an out-of-range value. The statement has been terminated.

How can I use the date data type in my schema and have EF behave? Thanks!

Answer

Craig Stuntz picture Craig Stuntz · Dec 16, 2009

Sounds like your SQL date column is non-nullable, but you haven't initialized the date on your entity before saving?

Related questions

Entity Framework: There is already an open DataReader associated with this Command

I am using Entity Framework and occasionally i will get this error. EntityCommandExecutionException {"There is already an open DataReader associated with this Command which must be closed first."} at System.Data.EntityClient.EntityCommandDefinition.ExecuteStoreCommands... Even though i am not doing …

Read More
Entity Framework 6 GUID as primary key: Cannot insert the value NULL into column 'Id', table 'FileStore'; column does not allow nulls

I have an entity with primary key "Id" which is Guid: public class FileStore { public Guid Id { get; set; } public string Name { get; set; } public string Path { get; set; } } And some configuration: protected override void OnModelCreating(DbModelBuilder modelBuilder) { modelBuilder.Entity&…

Read More
How to store images using Entity Framework Code First CTP 5?

I'm just trying to figure out if there is a simple way to store and retrieve binary (file) data using EF Code First CTP 5? I would really like it to use the FILESTREAM type, but I'm really just looking for …

Read More