[Mono-bugs] [Bug 584833] New: SqlCommandBuilder.DeriveParameters() does not find the correct stored procedure

[bugzilla_noreply at novell.com]

http://bugzilla.novell.com/show_bug.cgi?id=584833

http://bugzilla.novell.com/show_bug.cgi?id=584833#c0


           Summary: SqlCommandBuilder.DeriveParameters() does not find the
                    correct stored procedure
    Classification: Mono
           Product: Mono: Class Libraries
           Version: 2.6.x
          Platform: All
        OS/Version: All
            Status: NEW
          Severity: Major
          Priority: P5 - None
         Component: Sys.Data.SqlClient
        AssignedTo: mono-bugs at lists.ximian.com
        ReportedBy: Han.Wang at morningstar.com
         QAContact: mono-bugs at lists.ximian.com
          Found By: ---
           Blocker: Yes


Description of Problem:

SqlCommandBuilder.DeriveParameters() does not find the correct stored procedure

Steps to reproduce the problem:
1. Suppose you have a stored procedure at MS SQL Server:
"Database.dbo.StoredProcedure"
2. Suppose you have initialized and opened SqlConnection c

SqlConnection c=new SqlConnection(YourConnectionString);
c.Open();
SqlCommand cc=new SqlCommand();
cc.CommandType=CommandType.StoredProcedure;
cc.CommandText="Database.dbo.StoredProcedure";
cc.Connection=c;
SqlCommandBuilder.DeriveParameters(cc);



Actual Results:

You will get the exception: Stored procedure 'dbo.StoredProcedure' does not
exist.


Expected Results:

There should be no exception, the stored procedure exists and it seems
DeriveParameters() could not find the correct stored procedure name.



How often does this happen? 

Always



Additional Information:

-- 
Configure bugmail: http://bugzilla.novell.com/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the QA contact for the bug.
You are the assignee for the bug.