Bug #44985 No parameters from stored procedures when using ADO .NET Data Entities
Submitted: 20 May 15:43 Modified: 9 Sep 12:10
Reporter: Morten Andersen
Status: Closed
Category:Connector/Net Severity:S2 (Serious)
Version:6.0.4 OS:Microsoft Windows (Vista 32)
Assigned to: Reggie Burnett Target Version:
Tags: entities, entity, data entities, stored procedures, ADO
Triage: D3 (Medium)

[20 May 15:43] Morten Andersen 
Description:
When I create function imports in the Model Browser in Visual Studio .NET 2008 the
properties is not retrieved. All methods are imported, but none have any input
parameters.

How to repeat:
1. Create a stored procedure with input parameters
2. Add your stored procedure to your data entity scheme
3. Create a function import
4. Now, try to use the entity class that is generated. You should see the method there,
with the correct return type, but no input parameters
[19 Aug 9:45] Tonci Grgin 
SShot of problem.

Attachment: Bug44958.jpg (image/jpeg, text), 20.76 KiB.
[19 Aug 9:50] Tonci Grgin 
Hi Morten and thanks for your report. Verified as described. Might add my connection
string includes "use procedure bodies = true".

I used remote MySQL server 5.1.31 and functioning model with table main (ID Int not null
autoincrement primary key, Name varchar(50)) and following SP:
CREATE PROCEDURE `playground`.`fill_main` (IN startval INT)
    BEGIN
       set @x=startval;
       REPEAT
         INSERT INTO main VALUES(NULL, @x);
         SET @x=@x+1;
       UNTIL @x = 100
       END REPEAT;
     END $$

As can be seen in attached screen shot, there are no parameters in this SP discovered.
[21 Aug 17:06] 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/81319

747 Reggie Burnett	2009-08-21
      - fixed sql bug in our 6.0 table column ssdl.  I don't see how this would affect 
        stored procedure parameters but bug #44985 is now fixed
[21 Aug 17:08] Reggie Burnett 
fixed in 6.0.5 and 6.1.2+

Not sure how this patch fixes it but with this patch it now works as expected.
[9 Sep 12:10] Tony Bedford 
An entry was added to the 6.0.5 and 6.1.2 changelogs:

Input parameters were missing from Stored Procedures when using them with ADO.NET Data
Entities.