Bug #45457 DBType Time is not supported in Entity Framework
Submitted: 11 Jun 2009 16:43 Modified: 10 Aug 2009 15:51
Reporter: Joie Tagum Email Updates:
Status: Closed Impact on me:
None 
Category:Connector / NET Severity:S2 (Serious)
Version:6.0.3 OS:Any
Assigned to: CPU Architecture:Any

[11 Jun 2009 16:43] Joie Tagum
Description:
Calling Entity Framework SaveChanges() method of any MySQL (OR/M)Entity with a column type Time, an error message occurs as "Unknown PrimitiveKind Time".

How to repeat:
1.) Create a table and add a column with a DBType, TIME.
2.) Create a Conceptual Model in VS2008 Project and map your new table as an EntityObject.
3.) create an instance of your entityobject with a property type TimeSpan, specify new values, then call SaveChanges() in the objectcontext. 

Suggested fix:
To support Entity Framework, All known DB Types should be supported so developers can still work with the legacy application.
[5 Aug 2009 20:53] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/80220
[5 Aug 2009 20:56] Reggie Burnett
fixed in 6.0.5, 6.1.1+
[10 Aug 2009 15:51] Tony Bedford
An entry was added to the 6.0.5 and 6.1.1 changelogs:

Calling the Entity Framework SaveChanges() method of any MySQL ORM Entity with a column type TIME, generated an error message:

Unknown PrimitiveKind Time