Entity Framework - MySQL - Datetime format issue

Question

I have a simple table with few date fields.

Whenever I run following query:

var docs = ( from d in base.EntityDataContext.document_reviews
select d ).ToList();

I get following exception:

Unable to convert MySQL date/time value to System.DateTime. 
MySql.Data.Types.MySqlConversionException: Unable to convert MySQL date/time value to System.DateTime

The document reviews table has two date/time fields. One of them is nullable.

I have tried placing following in connection string:

Allow Zero Datetime=true;

But I am still getting exception.

Anyone with a solution?

sirrocco · Accepted Answer · 2010-04-29 17:31:51Z

12

@effkay - if you solved this it would be great if you could post the answer.

Also if anyone else has a solution that would be great too :).

Edit:

The solution can be found in the http://dev.mysql.com/doc/refman/5.1/en/connector-net-connection-options.html connector documentation.

I needed to set "Convert Zero Datetime" to true, and now it works.

hth.

edited Apr 29, 2010 at 17:31

answered Apr 27, 2010 at 17:24

sirrocco

8,0294 gold badges63 silver badges83 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

effkay Over a year ago

It was a bug in mysql provider for .net :(

Phoenix_uy Over a year ago

Nice tip the Convert Zero Datetime, but i have the problem that i cant insert from EF to mysql table the value '0000-00-00', and i need to.. is there a posibility to insert a value of datetime like that from EF?

womd Over a year ago

yes setting: Convert Zero Datetime=True in provider connection string part solved this for me

PodTech.io Over a year ago

updated ref link: dev.mysql.com/doc/connector-net/en/…

Daniel Rosenthal · Accepted Answer · 2013-08-15 16:05:22Z

5

You need to set Convert Zero Datetime=True in connection string of running application

edited Aug 15, 2013 at 16:05

Daniel Rosenthal

1,3965 gold badges15 silver badges33 bronze badges

answered Aug 15, 2013 at 15:43

Pankaj Singh

711 silver badge3 bronze badges

1 Comment

Rich Bianco Over a year ago

Works, thanks. Much easier than the coding solution!

Collectives™ on Stack Overflow

Entity Framework - MySQL - Datetime format issue

2 Answers 2

4 Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related