{"id":4586,"date":"2023-02-24T10:14:51","date_gmt":"2023-02-24T10:14:51","guid":{"rendered":"https:\/\/isophal.com\/?p=4586"},"modified":"2023-02-24T10:14:52","modified_gmt":"2023-02-24T10:14:52","slug":"crud-operations-using-entity-framework-in-asp-net-mvc","status":"publish","type":"post","link":"https:\/\/isophal.com\/news\/2023\/02\/24\/4586.html\/","title":{"rendered":"CRUD Operations using Entity Framework in ASP.NET MVC<\/strong>"},"content":{"rendered":"\n

In this and in few upcoming articles, I am going to discuss how to perform\u00a0CRUD operations using Entity Framework in ASP.NET MVC<\/strong>\u00a0application. Please read our previous article where we discussed how to\u00a0Delete Database Records in ASP.NET MVC<\/strong><\/a>\u00a0Application with some examples.<\/p>\n\n\n\n

Database Tables used in this Demo:<\/strong><\/h5>\n\n\n\n

In this demo, we are going to use the following\u00a0Department\u00a0<\/strong>and\u00a0Employee<\/strong>\u00a0table. So, please use the below SQL script to create and populate these 2 tables<\/p>\n\n\n\n

Create table Department\r\n(\r\n  Id int primary key identity,\r\n  Name nvarchar(50)\r\n)\r\nInsert into Department values('IT')\r\nInsert into Department values('HR')\r\nInsert into Department values('Payroll')\r\nCreate table Employee\r\n(\r\n  EmployeeId int Primary Key Identity(1,1),\r\n  Name nvarchar(50),\r\n  Gender nvarchar(10),\r\n  City nvarchar(50),\r\n  Salary decimal(18,2),\r\n  DepartmentId int\r\n)\r\nAlter table Employee add foreign key (DepartmentId) references Department(Id)\r\nInsert into Employee values('Mark','Male','London',1000,1)\r\nInsert into Employee values('John','Male','Chennai',2000,3)\r\nInsert into Employee values('Mary','Female','New York',3000,3)\r\nInsert into Employee values('Mike','Male','Sydeny',4000,2)\r\nInsert into Employee values('Scott','Male','London',3000,1)\r\nInsert into Employee values('Pam','Female','Falls Church',2000,2)\r\nInsert into Employee values('Todd','Male','Sydney',1000,1)\r\nInsert into Employee values('Ben','Male','New Delhi',4000,2)\r\nInsert into Employee values('Sara','Female','London',5000,1)<\/code><\/pre>\n\n\n\n
Create a new ASP.NET MVC 5 Web application:<\/strong><\/h5>\n\n\n\n
Open File => New =>Project<\/strong> and then select Installed => Templates => Visual C#. <\/strong>Then select ASP.NET Web Application<\/strong>. Provide the project name and location where you want to save your application and finally click on the OK<\/strong> button as shown in the below image.<\/p>\n\n\n\n
\"CRUD<\/figure>\n\n\n\n
From the next screen that is from select a template screen, select Empty<\/strong> as the project template. From add folder and core reference section check the MVC<\/strong> checkbox and click on OK<\/strong> as shown below.<\/p>\n\n\n\n
\"Selecting<\/figure>\n\n\n\n
Once you click on the OK button, it will take some time to create the project for us.<\/p>\n\n\n\n
Adding ADO.NET Entity Data Model<\/strong><\/h5>\n\n\n\n
Right-click on Models folder then select Add => New Item<\/strong> from the context menu that will open the Add New Item<\/strong> window. Select the Data<\/strong> tab from the left panel and then choose ADO.NET Entity Data Model<\/strong> from the middle panel. Provide a meaningful name for your data model and click on the Add<\/strong> button as shown in the below image.<\/p>\n\n\n\n
\"Adding<\/figure>\n\n\n\n
Selecting The Entity Framework Approach to interact with the database.<\/strong><\/h5>\n\n\n\n
Once you click on the Add button it will ask you to choose the entity framework approach. Here, we are going to use the database first approach as we already created the required database tables. So, from the Entity Data Model Wizard, select \u201cGenerate from database<\/strong>\u201d option and click \u201cNext<\/strong>\u201d as shown below.<\/p>\n\n\n\n
\"Selecting
Creating Database Connection:<\/strong>
On\u00a0\u201cChoose your data connection screen<\/strong>\u201d and click on the \u201cNew Connection<\/strong>\u201d button which will open the connection properties window. Here, we are going to interact with the SQL Server database. So, from the Data Source select\u00a0Microsoft SQL Server (SqlClient)<\/strong>. Provide your SQL Server name. Choose the Authentication type. Here, I am choosing\u00a0Windows Authentication<\/strong>. Then select the database to which you are going to interact from the\u00a0select or enter a database name<\/strong>\u00a0drop-down list. Finally,\u00a0click on the \u201cOK<\/strong>\u201d as shown below.
\"Creating
Then provide a meaningful connection string name such as \u201cEmployeeDBContext<\/strong>\u201d and click on the \u201cNext<\/strong>\u201d button as shown below.
\"CRUD
Choose Entity Framework Version:<\/strong>
Here, we are going to use Entity Framework 6. So, from the Choose Your Version screen, choose the\u00a0Entity framework 6.x\u00a0<\/strong>\u00a0and click on the\u00a0Next<\/strong>\u00a0button as shown below.
\"Selecting
Selecting Database Objects and Settings:<\/strong>
On \u201cChoose your database objects and Settings<\/strong>\u201d screen, expand the \u201cTables<\/strong>\u201d and then select \u201cDepartment<\/strong>\u201d and \u201cEmployee<\/strong>\u201d tables. Set Model Namespace as\u00a0Models<\/strong>\u00a0and click on the \u201cFinish<\/strong>\u201d button as shown in the below image.
\"Selecting
At this point, we should have\u00a0Department\u00a0<\/strong>and\u00a0Employee\u00a0entities generated as shown below.
\"CRUD<\/figcaption><\/figure>\n\n\n\n
Creating MVC 5 Controller:<\/h5>\n\n\n\n
Right-click on the \u201cControllers<\/strong>\u201d folder and select Add \u2013 Controller<\/strong> from the context menu. Then select MVC 5 Controller with views, using Entity Framework<\/strong> and click on the Add<\/strong> button as shown in the below image.<\/p>\n\n\n\n
\"Creating<\/figure>\n\n\n\n
On the next screen set the below details<\/strong><\/p>\n\n\n\n
    \n
  1. Model class = Employee (CRUD_Using_EF.Models)<\/strong><\/li>\n\n\n\n
  2. Data Context Class = EmployeeDBContext(CRUD_Using_EF.Models)<\/strong><\/li>\n\n\n\n
  3. Controller Name = EmployeeController<\/strong><\/li>\n\n\n\n
  4. Rest values are as it is and click on the Add button as shown in the below image<\/strong><\/li>\n<\/ol>\n\n\n\n
    \"Setting<\/figure>\n\n\n\n
    At this point, we should have the following files automatically added.<\/p>\n\n\n\n
    EmployeeController.cs<\/strong> file in \u201cControllers<\/strong>\u201d folder. Index, Create, Edit, Detail and Delete<\/strong> views in the \u201cEmployee<\/strong>\u201d folder which is inside the Views folder.<\/p>\n\n\n\n
    Below is the EmployeeController code<\/strong><\/h5>\n\n\n\n
    namespace CRUD_Using_EF.Controllers\r\n{\r\n    public class EmployeeController : Controller\r\n    {\r\n        private EmployeeDBContext db = new EmployeeDBContext();\r\n\r\n        \/\/ GET: Employee\r\n        public ActionResult Index()\r\n        {\r\n            var employees = db.Employees.Include(e => e.Department);\r\n            return View(employees.ToList());\r\n        }\r\n\r\n        \/\/ GET: Employee\/Details\/5\r\n        public ActionResult Details(int? id)\r\n        {\r\n            if (id == null)\r\n            {\r\n                return new HttpStatusCodeResult(HttpStatusCode.BadRequest);\r\n            }\r\n            Employee employee = db.Employees.Find(id);\r\n            if (employee == null)\r\n            {\r\n                return HttpNotFound();\r\n            }\r\n            return View(employee);\r\n        }\r\n\r\n        \/\/ GET: Employee\/Create\r\n        public ActionResult Create()\r\n        {\r\n            ViewBag.DepartmentId = new SelectList(db.Departments, \"Id\", \"Name\");\r\n            return View();\r\n        }\r\n\r\n        \/\/ POST: Employee\/Create\r\n        \/\/ To protect from overposting attacks, please enable the specific properties you want to bind to, for \r\n        \/\/ more details see http:\/\/go.microsoft.com\/fwlink\/?LinkId=317598.\r\n        [HttpPost]\r\n        [ValidateAntiForgeryToken]\r\n        public ActionResult Create([Bind(Include = \"EmployeeId,Name,Gender,City,Salary,DepartmentId\")] Employee employee)\r\n        {\r\n            if (ModelState.IsValid)\r\n            {\r\n                db.Employees.Add(employee);\r\n                db.SaveChanges();\r\n                return RedirectToAction(\"Index\");\r\n            }\r\n\r\n            ViewBag.DepartmentId = new SelectList(db.Departments, \"Id\", \"Name\", employee.DepartmentId);\r\n            return View(employee);\r\n        }\r\n\r\n        \/\/ GET: Employee\/Edit\/5\r\n        public ActionResult Edit(int? id)\r\n        {\r\n            if (id == null)\r\n            {\r\n                return new HttpStatusCodeResult(HttpStatusCode.BadRequest);\r\n            }\r\n            Employee employee = db.Employees.Find(id);\r\n            if (employee == null)\r\n            {\r\n                return HttpNotFound();\r\n            }\r\n            ViewBag.DepartmentId = new SelectList(db.Departments, \"Id\", \"Name\", employee.DepartmentId);\r\n            return View(employee);\r\n        }\r\n\r\n        \/\/ POST: Employee\/Edit\/5\r\n        \/\/ To protect from overposting attacks, please enable the specific properties you want to bind to, for \r\n        \/\/ more details see http:\/\/go.microsoft.com\/fwlink\/?LinkId=317598.\r\n        [HttpPost]\r\n        [ValidateAntiForgeryToken]\r\n        public ActionResult Edit([Bind(Include = \"EmployeeId,Name,Gender,City,Salary,DepartmentId\")] Employee employee)\r\n        {\r\n            if (ModelState.IsValid)\r\n            {\r\n                db.Entry(employee).State = EntityState.Modified;\r\n                db.SaveChanges();\r\n                return RedirectToAction(\"Index\");\r\n            }\r\n            ViewBag.DepartmentId = new SelectList(db.Departments, \"Id\", \"Name\", employee.DepartmentId);\r\n            return View(employee);\r\n        }\r\n\r\n        \/\/ GET: Employee\/Delete\/5\r\n        public ActionResult Delete(int? id)\r\n        {\r\n            if (id == null)\r\n            {\r\n                return new HttpStatusCodeResult(HttpStatusCode.BadRequest);\r\n            }\r\n            Employee employee = db.Employees.Find(id);\r\n            if (employee == null)\r\n            {\r\n                return HttpNotFound();\r\n            }\r\n            return View(employee);\r\n        }\r\n\r\n        \/\/ POST: Employee\/Delete\/5\r\n        [HttpPost, ActionName(\"Delete\")]\r\n        [ValidateAntiForgeryToken]\r\n        public ActionResult DeleteConfirmed(int id)\r\n        {\r\n            Employee employee = db.Employees.Find(id);\r\n            db.Employees.Remove(employee);\r\n            db.SaveChanges();\r\n            return RedirectToAction(\"Index\");\r\n        }\r\n\r\n        protected override void Dispose(bool disposing)\r\n        {\r\n            if (disposing)\r\n            {\r\n                db.Dispose();\r\n            }\r\n            base.Dispose(disposing);\r\n        }\r\n    }\r\n}<\/code><\/pre>\n\n\n\n
    At this point if you run the application you will get an error stating \u2013 The resource cannot be found<\/strong>. This is because by default the application goes to the \u201cHome<\/strong>\u201d controller and \u201cIndex<\/strong>\u201d action. To fix this, open \u201cRouteConfig.cs<\/strong>\u201d file from the \u201cApp_Start\u201d folder and set the controller as \u201cEmployee<\/strong>\u201d as shown below.<\/p>\n\n\n\n
    \"RouteConfig<\/figure>\n\n\n\n
    Run the application again. Notice that all the employees are listed on the index view. We can also create a new employee, edit an employee, view their full details and delete an employee as well. However, there are a few issues with each of the views which we will address in our upcoming articles.<\/p>\n\n\n\n
    In our next article, I am going to discuss what are the issues associated with the Index view and how will solve this<\/a><\/strong>. Here, in this article, I try to explain how to perform CRUD operations using Entity Framework in ASP.NET MVC<\/strong> application. I hope this article will help you with your needs. I would like to have your feedback. Please post your feedback, question, or comments about this article.<\/p>\n","protected":false},"excerpt":{"rendered":"
    In this and in few upcoming articles,…<\/p>\n","protected":false},"author":1,"featured_media":4587,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[189,140],"tags":[191,579,576,577],"class_list":["post-4586","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-asp-net","category-programming","tag-asp-net","tag-crud-operations","tag-entity-framework","tag-mvc"],"_links":{"self":[{"href":"https:\/\/isophal.com\/news\/wp-json\/wp\/v2\/posts\/4586","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/isophal.com\/news\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/isophal.com\/news\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/isophal.com\/news\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/isophal.com\/news\/wp-json\/wp\/v2\/comments?post=4586"}],"version-history":[{"count":1,"href":"https:\/\/isophal.com\/news\/wp-json\/wp\/v2\/posts\/4586\/revisions"}],"predecessor-version":[{"id":4588,"href":"https:\/\/isophal.com\/news\/wp-json\/wp\/v2\/posts\/4586\/revisions\/4588"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/isophal.com\/news\/wp-json\/wp\/v2\/media\/4587"}],"wp:attachment":[{"href":"https:\/\/isophal.com\/news\/wp-json\/wp\/v2\/media?parent=4586"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/isophal.com\/news\/wp-json\/wp\/v2\/categories?post=4586"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/isophal.com\/news\/wp-json\/wp\/v2\/tags?post=4586"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}