Does Entity Framework Code First support stored procedures?

by

EDIT: My original answer for EF4.1 (below) is now out of date. Please see the answer below from Diego Vega (who works on the EF team at Microsoft)!

@gsharp and Shawn Mclean: Where are you getting this information? Don’t you still have access to the underlying ObjectContext?

IEnumerable<Customer> customers = 
    ((IObjectContextAdapter)this)
    .ObjectContext.ExecuteStoreQuery<Customer>("select * from customers");

Replace the “select” statement with a stored proc, and there you go.

As for your other question: Yes, unfortunately your s.p.’s will get clobbered. You may need to add the “CREATE PROCEDURE” statements in your code.

For EF 4.2:

var customers = context.Database.SqlQuery<Customer>("select * from customers")

More Related Contents:

  1. Entity Framework Code First – two Foreign Keys from same table
  2. How to call Stored Procedure in Entity Framework 6 (Code-First)?
  3. Entity Framework Stored Procedure Table Value Parameter
  4. Getting data from stored procedure with Entity Framework
  5. Why use ICollection and not IEnumerable or List on many-many/one-many relationships?
  6. Validation failed for one or more entities while saving changes to SQL Server Database using Entity Framework
  7. Entity Framework DateTime and UTC
  8. Fluent API, many-to-many in Entity Framework Core
  9. Understanding ForeignKey attribute in entity framework code first
  10. Entity Framework – stored procedure return value
  11. Self-referencing many-to-many recursive relationship code first Entity Framework
  12. EF4 Code First: how to add a relationship without adding a navigation property
  13. Entity Framework Code First Date field creation
  14. How to call Stored Procedures with EntityFramework?
  15. Change foreign key constraint naming convention
  16. How to remove child one to many related records in EF code first database?
  17. Why does the EF 6 tutorial use asynchronous calls?
  18. composite key as foreign key
  19. One to one optional relationship using Entity Framework Fluent API
  20. Why is Asp.Net Identity IdentityDbContext a Black-Box?
  21. Navigation Property without Declaring Foreign Key
  22. Entity Framework Specification Pattern Implementation
  23. MySQL Entity Framework Error – The specified store provider cannot be found in the configuration, or is not valid
  24. Asking for legitimate example of calling stored procedure C#: MYSQL
  25. Global setting for AsNoTracking()?
  26. Json.Net adding $id to EF objects despite setting PreserveReferencesHandling to “None”
  27. Entity Framework Eager Load Not Returning Data, Lazy Load Does
  28. EF models. Navigation properties can only participate in a single relationship
  29. Seed Entities AND Users, Roles?
  30. Implementing recursive property loading in EF Core

Leave a Comment