Link for all dot net and sql server video tutorial playlists
Link for slides, code samples and text version of the video
In this video we will discuss using stored procedures to perform Insert, Update and Delete operations using entity framework code first approach.
public class EmployeeDBContext : DbContext
{
public DbSet[Employee] Employees { get; set; }
protected override void OnModelCreating(DbModelBuilder modelBuilder)
{
// This line will tell entity framework to use stored procedures
// when inserting, updating and deleting Employees
modelBuilder.Entity[Employee]().MapToStoredProcedures();
base.OnModelCreating(modelBuilder);
}
}
Entity Framework will create the following stored procedures automatically
Employee_Delete
Employee_Insert
Employee_Update
The default, naming convention for the stored procedures
INSERT stored procedure – EntityName_Insert
UPDATE stored procedure – EntityName_Update
DELETE stored procedure – EntityName_DeleteNote: Insert Stored procedure should return the auto-generated identity column value
