Insert Operation using ExecuteStoreCommand

Introduction

In this blog we will see how to perform insert operation using executestorecommand.

Program.cs

using System;
using System.Collections.Generic;
using System.Data.Entity.Infrastructure;
using System.Data.SqlClient;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
namespace ExecuteStoreCommand_Insert
{
class Program
{
static void Main(string[] args)
{
EmployeeEntities _dataContext = new EmployeeEntities();
SqlParameter firstName = new SqlParameter("FirstName", "Andy");
SqlParameter lastName = new SqlParameter("LastName", "Robes");
(_dataContext as IObjectContextAdapter).ObjectContext.ExecuteStoreCommand("spInsertEmployee @FirstName, @LastName", firstName, lastName);
_dataContext.SaveChanges();
Console.ReadKey();
}
}
}