Bug #55349 ADO Entity Framework cannot add Stored Procedures (MySQL Server 5.0.45)
Submitted: 18 Jul 2010 19:15 Modified: 7 Jan 2011 11:37
Reporter: Daniel Ulfe Email Updates:
Status: Closed Impact on me:
None 
Category:Connector / NET Severity:S2 (Serious)
Version:6.3.2 OS:Microsoft Windows (W7 x64 - VS 2010 Pro)
Assigned to: CPU Architecture:Any

[18 Jul 2010 19:15] Daniel Ulfe
Description:
The ADO.NET Entity Data Model cannot add stored procedures from a MySQL Server 5.0.45 but it works fine using a MySQL 5.1

How to repeat:
- Create a new Visual Studio Project - Web Site
- Create a new "ADO.NET Entity Data Model" 
- Select "Generate from database" (Click on NEXT)
- Select a connection string to a MySQL 5.0.45 server (Click on NEXT)
- Select any stored procedure in your DB. (Click on FINISH)

On the "Output Window" - "Entity Data Model" you will see the error:

Unable to generate the model because of the following exception: 'Object must implement IConvertible.
'.

And the stored procedure DOES NOT get added to the model.
[9 Dec 2010 3:27] 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/126376

851 Reggie Burnett	2010-12-08
      - fixed bug where older versions of MySQL would present cast(0 as decimal(0,0)) as string 
        that caused our EF code to throw an exception as it tried to convert that to bool
        (bug #55349)
[9 Dec 2010 3:40] Reggie Burnett
Fixed in 6.0.8, 6.1.6, 6.2.5, 6.3.6+
[7 Jan 2011 11:37] Tony Bedford
An entry has been added to the 6.0.8, 6.1.6, 6.2.5, and 6.3.6 changelogs:

The ADO.NET Entity Data Model could not add stored procedures from MySQL Server 5.0.45 but worked fine using MySQL Server 5.1.