Entity Framework – stored procedure return value

by

I guess support of stored procedure return values depends on version of Entity framework. Although directly returning value didn’t work for me I managed to get value using OUTPUT stored procedure parameter. Example:

USE [YOUR_DB_NAME]
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

CREATE PROCEDURE [dbo].[TestReturnValue]
    @InputValue int = 0,
    @Result int OUTPUT
AS
BEGIN
    SET NOCOUNT ON;
    SELECT @Result  = @InputValue
    RETURN(@InputValue);
END

This is test code:

void TestReturnValue()
{
    using (var db = new YourDBContext())
    {
        var result = new System.Data.Objects.ObjectParameter("Result", 0);
        Console.WriteLine("SP returned {0}", db.TestReturnValue(123, result));
        Console.WriteLine("Output param {0}", result.Value);
    }
}

And this is output:

SP returned -1
Output param 123

As you see directly returned value output some rubbish but OUTPUT parameters works!

This article provides general info on two ways of returning values from SP

Hope this helps

More Related Contents:

  1. Fastest Way of Inserting in Entity Framework
  2. How to call Stored Procedure in Entity Framework 6 (Code-First)?
  3. What are the pros and cons to keeping SQL in Stored Procs versus Code [closed]
  4. Entering keys manually with Entity Framework
  5. Entity Framework Stored Procedure Table Value Parameter
  6. Getting data from stored procedure with Entity Framework
  7. C# SQL Server – Passing a list to a stored procedure
  8. Difference between Parameters.Add(string, object) and Parameters.AddWithValue
  9. How can I log the generated SQL from DbContext.SaveChanges() in my Program? [duplicate]
  10. Validation failed for one or more entities while saving changes to SQL Server Database using Entity Framework
  11. Does Entity Framework Code First support stored procedures?
  12. LINQ to SQL multiple tables left outer join
  13. Passing List to SQL Stored Procedure
  14. Entity Framework error: Cannot insert explicit value for identity column in table
  15. Entity Framework. Delete all rows in table
  16. EF 6 Parameter Sniffing
  17. Retrieve an object from entityframework without ONE field
  18. Join and Include in Entity Framework
  19. Anonymous type result from sql query execution entity framework
  20. What is passing parameters to SQL and why do I need it?
  21. Add WHERE clauses to SQL dynamically / programmatically
  22. Calling a SQL User-defined function in a LINQ query
  23. How to pass a null variable to a SQL Stored Procedure from C#.net code
  24. How to call Stored Procedures with EntityFramework?
  25. Stored procedure returns int instead of result set
  26. How to use String property as primary key in Entity Framework
  27. Querying data using Entity Framework from dynamically created table
  28. How to execute an .SQL script file using c#
  29. Bulk-deleting in LINQ to Entities
  30. Entity Framework And Business Objects

Leave a Comment