Entity Framework - stored procedure return value
c#, entity-framework, sql, stored-procedures
Solution
No. Entity Framework doesn't have rich stored procedure support because its an ORM, not a SQL replacement.
As you have already discovered, if you need to use less common (more advanced?) features of stored procedures, you'll have to use good old fashioned ADO.NET.
Problem
I am trying to get the return value of a stored procedure. Here is an example of such a stored procedure: ``` select Name, IsEnabled from dbo.something where ID = @ID if @@rowcount = 0 return 1 return ``` This is a simple select. If 0 rows are found, my result set will be null, but I will still have a return value. This is a bad example, as this is a select, so sure I could find if 0 rows were returned. However, on an Insert, delete, or other calls, we need this return value to know if there was a problem. I have been unable to find a way to get this return value. I can get output values, I can get result sets, but no return value. I can get the return value if I call SQL manually, or even if I run a `SqlCommand` using the Entity Framework, but this is not what I want to do. Has anyone ever been able to get the return value from a stored procedure using Entity Framework? Thanks for the help!