dotnet0824
asked on
Enterprise Library 3.1 Catch Return value from stored procedure
Hi,
I am using Microsoft Enterprise library 3.1 in my DataAccessLayer. My stored procedure has a return value
How do i get my return value in my code in DataAccessLayer... I have seen Outputparameter values can be easily retrieved . but how about return values from stored procedure . If return =-1 I want to catch it in my code
like Create procedure sp_GetEmployee
Select * from employee
if @@ERROR!=0
Begin
return -1
END
I am using Microsoft Enterprise library 3.1 in my DataAccessLayer. My stored procedure has a return value
How do i get my return value in my code in DataAccessLayer... I have seen Outputparameter values can be easily retrieved . but how about return values from stored procedure . If return =-1 I want to catch it in my code
like Create procedure sp_GetEmployee
Select * from employee
if @@ERROR!=0
Begin
return -1
END
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Were you able to find a way to get the return parameter from Stored procedure using enterprie library 3.1?