How to call Stored Procedures with EntityFramework?

One way is to use the Database property off the DbContext:

SqlParameter param1 = new SqlParameter("@firstName", "Frank");
SqlParameter  param2 = new SqlParameter("@lastName", "Borland");
context.Database.ExecuteSqlCommand("sp_MyStoredProc @firstName, @lastName", 
                              param1, param2);

EF5 definitely supports that.

Related Contents:

  1. How to call Stored Procedure in Entity Framework 6 (Code-First)?
  2. Entity Framework Stored Procedure Table Value Parameter
  3. Getting data from stored procedure with Entity Framework
  4. Does Entity Framework Code First support stored procedures?
  5. LINQ to SQL multiple tables left outer join
  6. Dynamic MySQL database connection for Entity Framework 6
  7. Error-Attempt by method ‘X.set_DbConnection(System.Data.Common.DbConnection)’ to access method ‘Y.get_Settings()’ failed
  8. Entity Framework – stored procedure return value
  9. MySQL Entity Framework Error – The specified store provider cannot be found in the configuration, or is not valid
  10. MySQL – Entity : The value for column ‘IsPrimaryKey’ in table ‘TableDetails’ is DBNull
  11. The entity cannot be constructed in a LINQ to Entities query
  12. ASP.NET MVC – Attaching an entity of type ‘MODELNAME’ failed because another entity of the same type already has the same primary key value
  13. Validation failed for one or more entities. See ‘EntityValidationErrors’ property for more details [duplicate]
  14. EntityFramework – contains query of composite key
  15. Solving “The ObjectContext instance has been disposed and can no longer be used for operations that require a connection” InvalidOperationException
  16. What does principal end of an association means in 1:1 relationship in Entity framework
  17. Dynamic where clause (OR) in Linq to Entities
  18. How to create LINQ Expression Tree to select an anonymous type
  19. Why does the EF 6 tutorial use asynchronous calls?
  20. Capture Stored Procedure print output in .NET
  21. Update Row if it Exists Else Insert Logic with Entity Framework [closed]
  22. Insert/Update Many to Many Entity Framework . How do I do it?
  23. Circular reference detected exception while serializing object to JSON
  24. Exception: There is already an open DataReader associated with this Connection which must be closed first
  25. Get return value from stored procedure
  26. How can I log the generated SQL from DbContext.SaveChanges() in my Program? [duplicate]
  27. How to form a correct MySQL connection string? [closed]
  28. Why doesn’t Include have any effect?
  29. Entity Framework DateTime and UTC
  30. Many-to-many mapping table
  31. No connection string named ‘MyEntities’ could be found in the application config file
  32. Entity Framework 6 transaction rollback
  33. Non-static method requires a target
  34. Lazy Loading vs Eager Loading
  35. LINQ to Entities only supports casting EDM primitive or enumeration types with IEntity interface
  36. Entity Framework: How to disable lazy loading for specific query?
  37. Adding stored procedures complex types in Entity Framework
  38. Convert DateTime for MySQL using C#
  39. How to add the same column to all entities in EF Core?
  40. How to group by on 2 child entities and get total of both this child entities?
  41. Dynamic query with OR conditions in Entity Framework
  42. Generate EF orderby expression by string [duplicate]
  43. Entity Framework And Business Objects
  44. Setting unique Constraint with fluent API?
  45. How to COUNT rows within EntityFramework without loading contents?
  46. An error occurred while saving entities that do not expose foreign key properties for their relationships
  47. Entity Framework DB-First, implement inheritance
  48. Database.BeginTransaction vs Transactions.TransactionScope [duplicate]
  49. Update records using LINQ
  50. “Context cannot be used while the model is being created” exception with ASP.NET Identity

Leave a Comment