How to call Stored Procedures with EntityFramework?

by

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.

More 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. Entity Framework – stored procedure return value
  8. Error-Attempt by method ‘X.set_DbConnection(System.Data.Common.DbConnection)’ to access method ‘Y.get_Settings()’ failed
  9. MySQL Entity Framework Error – The specified store provider cannot be found in the configuration, or is not valid
  10. Asking for legitimate example of calling stored procedure C#: MYSQL
  11. Testing an Entity Framework database connection
  12. Entity Framework async operation takes ten times as long to complete
  13. How to update record using Entity Framework 6?
  14. Serialization of Entity Framework objects with One to Many Relationship
  15. DbEntityValidationException – How can I easily tell what caused the error?
  16. Save and retrieve image (binary) from SQL Server using Entity Framework 6
  17. Setting unique Constraint with fluent API?
  18. Lazy Loading vs Eager Loading
  19. Does Entity Framework 4 Code First have support for identity generators like NHibernate?
  20. Unable to connect to any of the specified mysql hosts. C# MySQL
  21. LINQ to Entities does not recognize the method ‘System.Web.Mvc.FileResult’
  22. Problems using Entity Framework 6 and SQLite
  23. The remote server returned an unexpected response: (413) Request Entity Too Large.
  24. Log Queries executed by Entity Framework DbContext
  25. An error occurred while saving entities that do not expose foreign key properties for their relationships
  26. Entity Framework Code First Date field creation
  27. “Context cannot be used while the model is being created” exception with ASP.NET Identity
  28. Entity Framework 4.1: Unable to cast from DbQuery to ObjectQuery
  29. Entity framework: StoreGeneratedPattern=”Computed” property
  30. How to include() nested child entity in linq

Leave a Comment