conversion of a datetime2 data type to a datetime data type error with EF Code first?

c# sql-server-2008 entity-framework ef-code-first entity-framework-4.3
Mohammad Zare picture Mohammad Zare · May 14, 2012 · Viewed 42k times · Source

I'm using EF Code first with my asp.net mvc application. here is my code:

Request.RequestDate = DateTime.Now;

the type of RequestDate is datetime in my database. and this is error that occurred when i use the above code!:

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

please help me. thanks.

Answer

Blast_dan picture Blast_dan · May 14, 2012

Edit:

How to fix the datetime2 out-of-range conversion error using DbContext and SetInitializer?

The issue is that you are trying to save a value that cannot fit in a SQL datetime column. the answer givin here will stop the conversion from failing.

or in your Database change the columns to be type datetime2. I don't exactly know why they code first is generating datetime columns instead of datetime2

Here is an example to explicitly map your Datetime columns to datetime2 in SQL

Using DateTime properties in Code-First Entity Framework and SQL Server

Related questions

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 read / write geography data using C#, Entity Framework and SQL Server 2008?

I have a form from which the user will be able to enter the latitude and longitude of a certain point on the map. The data will be input as string values. I did some research and found out from …

Read More
Entity Framework query performance differs extrem with raw SQL execution

I have a question about Entity Framework query execution performance. Schema: I have a table structure like this: CREATE TABLE [dbo].[DataLogger] ( [ID] [bigint] IDENTITY(1,1) NOT NULL, [ProjectID] [bigint] NULL, CONSTRAINT [PrimaryKey1] PRIMARY KEY CLUSTERED ( [ID] ASC ) ) CREATE TABLE [dbo].[…

Read More