title: Unable to convert MySQL date/time value to System.DateTime in VS2010
body: <p>when I want to load data from my mysql database I always get this error:</p>
  
  <blockquote>
    <p>Unable to convert MySQL date/time value to System.DateTime</p>
  </blockquote>
  
  <p>This is my connectionstring:</p>
  
  <pre><code>&lt;add name="gdmwebsiteEntities" 
       connectionString="metadata=res://*/Models.DBModel.csdl|res://*/Models.DBModel.ssdl|res://*/Models.DBModel.msl;provider=MySql.Data.MySqlClient;provider connection string=&amp;quot;server=localhost;User Id=root;database=gdmwebsite&amp;quot;" 
       providerName="System.Data.EntityClient" /&gt;
  </code></pre>
  
  <p>I've already added "Convert Zero Datetime=True" add the end of my connectionstring but nothing changed. <br></p>
  
  <pre><code>    &lt;add name="gdmwebsiteEntities" 
       connectionString="metadata=res://*/Models.DBModel.csdl|res://*/Models.DBModel.ssdl|res://*/Models.DBModel.msl;provider=MySql.Data.MySqlClient;provider connection string=&amp;quot;server=localhost;User Id=root;database=gdmwebsite&amp;quot;
       Convert Zero Datetime=True
        Allow Zero Datetime=True"
       providerName="System.Data.EntityClient" /&gt;
  </code></pre>
  
  <p>Is there another method for fixing this?</p>