Allow Zero DateTime mysql connector web.config Entity Framework

Question

I'm getting a MySqlConnectionException when i'm trying to connect retrieve data from my DBContext class because i have a date time entry line 0000-00-00 00:00:00.

From what i understand i have to add a Allow Zero Datetime=true entry in my connection string, the one bellow.

<add name="A4LifeEntities" connectionString="metadata=res://*/A4LifeEntities.csdl|res://*/A4LifeEntities.ssdl|res://*/A4LifeEntities.msl;provider=MySql.Data.MySqlClient;provider connection string=&quot;server=localhost;password=pass;user id=userId;port=3330;Allow Zero Datetime=true; persist security info=True;database=aLife&quot;" providerName="System.Data.EntityClient"/></connectionStrings>

As you can see i have already added it, but am i doing something wrong ? Do i have to add it somewhere else in the string ? Because it's not working.

Thank you

See this

Gert Arnold
– Gert Arnold

2013-03-30 21:18:05 +00:00
Commented Mar 30, 2013 at 21:18 — Gert Arnold
– Gert Arnold, Commented Mar 30, 2013 at 21:18

Rob G · Accepted Answer · 2013-03-31 00:01:29Z

12

Use Convert Zero Datetime=true;, it's different in that it returns DateTime.MinValue instead of a MySqlDateTime.

answered Mar 31, 2013 at 0:01

Rob G

3,5561 gold badge22 silver badges29 bronze badges

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

3 Comments

Burak Karakuş Over a year ago

Hey. When I add this to my connection string, it gives an error like 'Format of the initialization string does not conform to specification starting at index 0' Here is my conn string: "<add name="xyzEntities" connectionString="metadata=res://*/xyz.csdl|res://*/xyz.ssdl|res://*/xyz.msl;provider=MySql.Data.MySqlClient;provider connection string="server=localhost;user id=root;database=xyz"Convert Zero Datetime=true;" providerName="System.Data.EntityClient" />" What should I do?

softawareblog.com Over a year ago

@BurakKarakuş "Convert Zero Datetime=true;" should be after "database=xyz;" not after """

Ton Over a year ago

id=root;database=xyz"Convert Zero Datetime=true; should be: id=root;database=xyz";Convert Zero Datetime=true; Because " consumes one ; and then there is no commandseparation anymore

Collectives™ on Stack Overflow

Allow Zero DateTime mysql connector web.config Entity Framework

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related