Entity Framework Pitfalls: Using Stored Procedures for Basic Operations
Entity Framework, as of version 6, allows the usage of stored procedures for its CUD (Create, Update and Delete) operations. We just need to override the DbContext’s OnModelCreating method and call MapToStoredProcedures.
protected override void OnModelCreating(DbModelBuilder modelBuilder)
{modelBuilder.Entity<Master>().MapToStoredProcedures();
//rest goes here base.OnModelCreating(modelBuilder);}
The problem is, this is all or nothing: you cannot use a stored procedure for just one of the operations, you need to use stored procedures for all operations. And, no, it is not possible (yet) to use custom SQL, just stored procedures.