Get @Return_Value from stored procedure using Entity

Question

I want to get @Return_Value from stored procedure using entity.

Lets say stored procedure is:

CREATE PROCEDURE GetEmployes( @whereSql nvarchar(512) )
AS
BEGIN
    set @tsql = 'select * from Employes where '  + @whereSql
    exec(@tsql)
    return 5
END

Entity imports is as

ObjectResult<Employe> GetEmployes(...)

This is what I need.

int return_value;
var result = db.GetEmpleys("name = .. AND ...", out return_value);
if (return_value == 5)
     // do something on this exit code
List<Employe> result.ToList<Employe>() ;

I am using Visual Studio 2008

TIA

Answer 1

The notion of the int return value is SQL Server specific. I don't believe that the EF, which is designed to be DB-server-agnostic, supports it.

So you have to use proper output params, not the int return value. That should not be a problem. Worst case, wrap the proc in another proc which returns the int return value of the first as an output of the second.

Finally, I hope this is just an example, as your demo proc introduces an SQL injection vulnerability.