How to call Stored Procedure in Entity Framework 6 (Code-First)?

by

You can call a stored procedure in your DbContext class as follows.

this.Database.SqlQuery<YourEntityType>("storedProcedureName",params);

But if your stored procedure returns multiple result sets as your sample code, then you can see this helpful article on MSDN

Stored Procedures with Multiple Result Sets

More Related Contents:

  1. Entity Framework Stored Procedure Table Value Parameter
  2. Getting data from stored procedure with Entity Framework
  3. Does Entity Framework Code First support stored procedures?
  4. Entity Framework – stored procedure return value
  5. How to call Stored Procedures with EntityFramework?
  6. summing values of a column based on id [closed]
  7. Decimal precision and scale in EF Code First
  8. Entity Framework .Remove() vs. .DeleteObject()
  9. Why is inserting entities in EF 4.1 so slow compared to ObjectContext?
  10. Entity Framework error: Cannot insert explicit value for identity column in table
  11. Dynamic MySQL database connection for Entity Framework 6
  12. How do I clear tracked entities in entity framework
  13. Entity framework, problems updating related objects
  14. Why is Asp.Net Identity IdentityDbContext a Black-Box?
  15. Navigation Property without Declaring Foreign Key
  16. Entity Framework Specification Pattern Implementation
  17. MySQL Entity Framework Error – The specified store provider cannot be found in the configuration, or is not valid
  18. Asking for legitimate example of calling stored procedure C#: MYSQL
  19. How to I apply filter while paginating in Asp.net MVC and entity Framework?
  20. Global setting for AsNoTracking()?
  21. Json.Net adding $id to EF objects despite setting PreserveReferencesHandling to “None”
  22. Remove item from list based on condition
  23. Unit testing with EF Core and in memory database
  24. Entity Framework Eager Load Not Returning Data, Lazy Load Does
  25. EF models. Navigation properties can only participate in a single relationship
  26. Seed Entities AND Users, Roles?
  27. How to include() nested child entity in linq
  28. Oracle Entity Framework – Generate Entity From Tables in Different Schema
  29. Entity framework – get entity by name
  30. LINQ Query to Convert string to datetime

Leave a Comment