Allow Zero DateTime mysql connector web.config Entity Framework
asp.net, asp.net-mvc, entity-framework, mysql, web-config
Solution
Use `Convert Zero Datetime=true;`, it's different in that it returns DateTime.MinValue instead of a MySqlDateTime.
Problem
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="server=localhost;password=pass;user id=userId;port=3330;Allow Zero Datetime=true; persist security info=True;database=aLife"" 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