MySQL Bugs: #55349: ADO Entity Framework cannot add Stored Procedures (MySQL Server 5.0.45)

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:	Windows (W7 x64 - VS 2010 Pro)
Assigned to:		CPU Architecture:	Any

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.

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)

Fixed in 6.0.8, 6.1.6, 6.2.5, 6.3.6+

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.