MySQL Bugs: #48790: Adding stored procedure to Entity framework model fails

Bug #48790	Adding stored procedure to Entity framework model fails
Submitted:	16 Nov 2009 5:56	Modified:	16 Dec 2009 15:12
Reporter:	passsha passsha	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	Connector / NET	Severity:	S1 (Critical)
Version:	6.2.0	OS:	Windows
Assigned to:	Assigned Account	CPU Architecture:	Any

Description:
I tried to add my new stored procedure to entity framework model but i got error when i click finish on update model from database wizard:
An exception of type
'Microsoft.Data.Entity.Design.VisualStudio.ModelWizard.Engine.ModelBuilderEngine+GenerateSSDLException' occurred while attempting to update from the database. The exception message is: 'Specified cast is not valid.
'.
Then I tried to add new empty SP:
CREATE PROCEDURE `my_db`.`my_proc` ()
BEGIN
END

but that fails too :(

How to repeat:
Create a database with stored procedure, run MS Visual Studio 2008, run Entity Data Model Wizard, choose connection to database, then choose stored procedure you want to add into the model.

Hi again Passsha.

Same as for your previous report, can you please attach your project and a database dump that I can load? If you're concerned about safety, add files privately.

Also, since you use latest c/NET anyway, there is 6.2.1 available now.

I have tried to use different workstaions an operation systems such as MS Windows Xp SP2 and SP3, Microsoft Windows 7 also. All of workstations have dual-core CPU and more then 2GB of RAM. MySQL Server version is 5.0.45.

Passsha, please see my comment from 2 hours ago.

Many thanks for you quick reply! I saw your comment and added a database dump privately. But I don't think that it is necessary to add the project because this bug and bug http://bugs.mysql.com/bug.php?id=48791 can be repeated with a new empty project. 
Regards, Pavel.

Pavel, well I'll try without the project but such errors can come out of various connection string settings thus I wanted entire project attached.

Pavel, this one I can not confirm... I used same project database as for Bug#48791, created new SP (spbug48791) with single input param and code SELECT SLEEP(param1). Model was updated successfully.

Can you provide me with actual SP that fails based on database you already attached?

Yours + mine SP in model.

Attachment: Bug48790.jpg (image/jpeg, text), 12.04 KiB.

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".

I am running into an issue with the same procedure that you tried, Tonci.

You created the sp and added it and it got added fine. But you said you created it with a parameter param1, however when you get it in the model browser, as you can see it is showing it without the parameter. 

I was using devart dotConnect driver for mySql connection, am trying to switch to Connector/Net driver. The old function imports created by dotConenct recognized these parameters. Any note on how to deal with this?