当我想从我的mysql数据库加载数据时,我总是收到此错误:
Unable to convert MySQL date/time value to System.DateTime
这是我的连接字符串:
connectionString="metadata=res://*/Models.DBModel.csdl|res://*/Models.DBModel.ssdl|res://*/Models.DBModel.msl;provider=MySql.Data.MySqlClient;provider connection string="server=localhost;User Id=root;database=gdmwebsite""
providerName="System.Data.EntityClient" />
我已经添加了“Convert Zero Datetime = True”添加我的connectionstring的结尾但没有任何改变.
connectionString="metadata=res://*/Models.DBModel.csdl|res://*/Models.DBModel.ssdl|res://*/Models.DBModel.msl;provider=MySql.Data.MySqlClient;provider connection string="server=localhost;User Id=root;database=gdmwebsite"
Convert Zero Datetime=True
Allow Zero Datetime=True"
providerName="System.Data.EntityClient" />
还有另一种解决方法吗?