Get return value from stored procedure

by

I found it!
I can read the return value with an output parameter that has to be used in this way:

// define a new output parameter
var returnCode = new SqlParameter();
returnCode.ParameterName = "@ReturnCode";
returnCode.SqlDbType = SqlDbType.Int;
returnCode.Direction = ParameterDirection.Output;

// assign the return code to the new output parameter and pass it to the sp
var data = _context.Database.SqlQuery<Item>("exec @ReturnCode = spItemData @Code, @StatusLog OUT", returnCode, code, outParam);

More Related Contents:

  1. Calling stored procedure with return value
  2. Entity Framework Stored Procedure Table Value Parameter
  3. Entity Framework (EF) Code First Cascade Delete for One-to-Zero-or-One relationship
  4. Calculated column in EF Code First
  5. Mapping Database Views to EF 5.0 Code First w/Migrations
  6. EF5 Code First – Changing A Column Type With Migrations
  7. Modelling polymorphic associations database-first vs code-first
  8. Entity Framework 5 Updating a Record
  9. What are the pros and cons to keeping SQL in Stored Procs versus Code [closed]
  10. Decimal precision and scale in EF Code First
  11. How can I automatically filter out soft deleted entities with Entity Framework?
  12. C# SQL Server – Passing a list to a stored procedure
  13. composite key as foreign key
  14. Implementing Zero Or One to Zero Or One relationship in EF Code first by Fluent API
  15. Many-to-many mapping table
  16. Does Entity Framework Code First support stored procedures?
  17. Entity Framework (.NET Full Framework) Ordering Includes [duplicate]
  18. Overriding SaveChanges and setting ModifiedDate, but how do I set ModifiedBy?
  19. Does Entity Framework 4 Code First have support for identity generators like NHibernate?
  20. How to disable cascade delete for link tables in EF code-first?
  21. Entity framework, problems updating related objects
  22. Exclude a field/property from the database with Entity Framework 4 & Code-First
  23. How to configure many to many relationship using entity framework fluent API
  24. Navigation Property without Declaring Foreign Key
  25. Asking for legitimate example of calling stored procedure C#: MYSQL
  26. Is it Possible to Return a Reference to a Variable in C#? [duplicate]
  27. An error occurred while saving entities that do not expose foreign key properties for their relationships
  28. EF5 Getting this error message: Model compatibility cannot be checked because the database does not contain model metadata
  29. Add WHERE clauses to SQL dynamically / programmatically
  30. Entity Framework: field of composite key cannot be nullable?

Leave a Comment