So I got the MySQL ADO.NET adapter installed and then using the Entity framework, generated a bunch of model classes. I was getting this error when selecting data from a certain table:

Unable to convert MySQL date/time value to System.DateTime

So after researching that real quick, I added this to my web.config for my mysql connection string:

Allow Zero Datetime=True;

However I am now getting the following error:

Object reference not set to an instance of an object.

This has something to do with one of my fields in my database holding '0000-00-00 00:00:00' as the value because if I set that to some other valid timestamp it works fine however this field is often going to hold zero data as it is only updated if the record is updated. I have also tried allowing NULL for the field and setting it to null but the same error comes up. Does anyone know how to fix this issue?