Introduction

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

Program.cs

  1. using System;
  2. using System.Collections.Generic;
  3. using System.Data.Entity.Infrastructure;
  4. using System.Data.SqlClient;
  5. using System.Linq;
  6. using System.Text;
  7. using System.Threading.Tasks;
  8. namespace ExecuteStoreCommand_Update
  9. {
  10. class Program
  11. {
  12. static void Main(string[] args)
  13. {
  14. EmployeeEntities _dataContext = new EmployeeEntities();
  15. SqlParameter empId = new SqlParameter("EmpId", "1");
  16. SqlParameter firstName = new SqlParameter("FirstName", "Andy");
  17. SqlParameter lastName = new SqlParameter("LastName", "Robes");
  18. (_dataContext as IObjectContextAdapter).ObjectContext.ExecuteStoreCommand("spUpdateEmployee @EmpId, @FirstName, @LastName", empId, firstName, lastName);
  19. _dataContext.SaveChanges();
  20. Console.ReadKey();
  21. }
  22. }
  23. }
Summary

In this article we have seen how we can perform update operation using executestorecommand. Happy coding!