Bug #45457 DBType Time is not supported in Entity Framework

• Submitted: 11 Jun 18:43
• Modified: 10 Aug 17:51
• Reporter: Joie Tagum
• Status: Closed
• Category: Connector/Net
• Severity: S2 (Serious)
• Version: 6.0.3
• OS: Any

[11 Jun 18: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 22: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 22:56] Reggie Burnett

fixed in 6.0.5, 6.1.1+

[10 Aug 17: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