How to retrieve values of multiple output parameters of Stored Procedure in Linq to SQL

Question

0.00/5 (No votes)

See more:

Hi,
I am using MVC 4 with Linq to SQL class and using stored procedure for my transaction.
I have simple stored procedure having two output parameters with different data types. I am struggling to retrieve the values of both return by stored procedure.

My SP like as :

SQL

Create Procedure [dbo].[tblMgmt_test_sp] 
@numAmt_Actual int=0 output, 
@return varchar(20)=null output  
AS  
.....
....

And my Controller action is as -

C#

int? numAmt_Actual = 1;
string returnVal = "";

var strResult = datacontext.tblMgmt_test_sp(ref numAmt_Actual ,ref returnVal);

Not sure which datatype to hold the result of datacontext.tblMgmt_test_sp and how?

Can you please help me regarding this issue?

Posted 14-Oct-15 1:06am

Ajay_Saini

Updated 14-Oct-15 1:22am

Maciej Los

v2

Add a Solution

Comments

[no name] 14-Oct-15 7:27am

If it is a varchar type in SQL server then string is fine. Your code looks OK. Are you getting any kind of exception?

Ajay_Saini 14-Oct-15 7:59am

No, i didn't get any exception and any value of output variable i.e. @numAmt_Actual and @return in my case (if i use different data types).
And yes if both the output valuables are of same type then i got both values but for different type then i got following exception -

'System.Void' is not a valid return type for a mapped stored procedure method.

Even the return type i have seen in designer class is not as 'Void'

Sinisa Hajnal 14-Oct-15 11:16am

Void means it didn't return anything. What are you expecting from the stored procedure? DataSet? Did you check that SP really returns some data?

Ajay_Saini 14-Oct-15 12:14pm

I just want to get the values of out variables define in stored procedure but keeping in mind that both the output variables have different data types.

Ajay_Saini 15-Oct-15 1:23am

Hi Sinisa,
I have checked again and found the values at this time, not sure what is the problem as same code i have tested in my morning and seems working for me now.

Sinisa Hajnal 15-Oct-15 8:10am

Excellent. Please mark the question solved or delete it if there is no viable solution. Thank you.

2 solutions

Solution 1

http://stackoverflow.com/questions/6999441/sql-server-2008-stored-procedure-with-multiple-output-parameters[^]

Posted 14-Oct-15 3:58am

$*Developer - Vaibhav*$

Comments

Ajay_Saini 14-Oct-15 12:20pm

This is not a solution as per my problem.
I can retrieve multiple out variables in case of ado or ado.net but how to get all the out variable's value in MVC using Linq to SQL is my concern. Please read my question for more info.

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Ajay_Saini · Accepted Answer · 2015-10-15T02:31:00

Solution 3

The above query is fixed at my end without modifying any part in my code.

Posted 15-Oct-15 2:31am

Ajay_Saini