--- title: "How to Add Update Delete using entity framework" description: "How to Add Update Delete using entity framework" author: "Jonas Stuart" published: 2017-02-01 updated: 2017-03-27 canonical: https://www.mindstick.com/forum/34255/how-to-add-update-delete-using-entity-framework category: "asp.net mvc" tags: ["bootstrap", "mvc", "entity framework", "validation"] reading_time: 10 minutes --- # How to Add Update Delete using entity framework Hi Buddy\ Please help me How to [Add](https://www.mindstick.com/forum/12983/add-address-in-textbox-when-page-is-load-and-if-i-search-address-in-textbox-show-in-map-by-javascript) [Update Delete](https://www.mindstick.com/forum/34184/how-to-insert-update-delete-data-from-database-using-c-sharp) using [entity framework](https://www.mindstick.com/articles/1566/crud-operations-using-entity-framework-code-first-approach) .\ Thanks\ \ \ ## Replies ### Reply by Vijay Saklani Hi, Check this link:\ http://www.aspmantra.com/search/label/Entity%20Framework\ thanks,Vijay ### Reply by Manish Kumar I am providing you the solution of your question. Using [entity](https://www.mindstick.com/forum/160562/database-connectivity-using-entity-framework-database-first-approach) [framework](https://www.mindstick.com/forum/34615/software-framework-vs-library) and repository pattern First create a demo database and create table RegistrationForm ``` CREATE TABLE [dbo].[RegistrationForm](          [Id] [int] IDENTITY(1,1) NOT NULL,          [FName] [varchar](50) NULL,          [MName] [varchar](50) NULL,          [LName] [varchar](50) NULL,          [Dob] [datetime] NOT NULL,          [Mobile] [nchar](10) NULL,          [City] [varchar](50) NULL,          [Pin] [varchar](50) NULL,          [Address] [varchar](250) NULL,) ``` And CountryList table and Insert record ``` CREATE TABLE [dbo].[CountryList](          [Id] [int] IDENTITY(1,1) NOT NULL,          [Country] [varchar](50) NULL,) ``` Then create a new project and right click on model folder and select ado.net entity data model \ ![How to Add Update Delete using entity framework](https://www.mindstick.com/mindstickforums/2be5b77d-fae0-4bde-8833-f8e2519af4c0/images/50af0a53-82de-426a-a19c-70f5e427b734.png)\ \ And then And next and give sever and user name and password and select your database .Then your entity framework will be generated. It will look like this ![How to Add Update Delete using entity framework](file:///C:\Users\MSCLIE~1\AppData\Local\Temp\msohtmlclip1\01\clip_image004.png)![How to Add Update Delete using entity framework](https://www.mindstick.com/mindstickforums/2be5b77d-fae0-4bde-8833-f8e2519af4c0/images/76eebf17-a566-481f-bcc6-e72ea0e9964f.png) For data annotation we have to add another class in model we cannot add data annotation in generated models class because when we [update](https://www.mindstick.com/forum/156353/what-is-hummingbird-update) our entity framework our important validation will be loss to recover from this problem we will create meta class in the models folder. And add following code ``` using System;using System.Collections.Generic;using System.Linq;using System.Web;using System.ComponentModel.DataAnnotations;using System.ComponentModel.DataAnnotations.Schema; namespace TestSol.Models{    public class RegistrationFormMeta    {        public int Id { get; set; }         [Required(ErrorMessage="First Name is require!!")]        public string FName { get; set; }         public string MName { get; set; }        public string LName { get; set; }        public DateTime Dob { get; set; }        public string Mobile { get; set; }        public string City { get; set; }                   [Required(ErrorMessage="pin is require!!")]       [RegularExpression("^[0-9]{6}$" , ErrorMessage = "Pin must be Numeric and <=6")]        public string Pin { get; set; }         public string Address { get; set; }    }    public class CountryListMeta    {        public int Id { get; set; }        public string Country { get; set; }    }} ``` Meta classes contain all the validation attribute to associate this class to metadata add a class in the models folder and name it Partial ``` using System;using System.Collections.Generic;using System.Linq;using System.Web;using System.ComponentModel.DataAnnotations; namespace TestSol.Models{    [MetadataType(typeof(RegistrationFormMeta))]    public partial class RegistrationForm    {    }    [MetadataType(typeof(CountryListMeta))]    public partial class CountryList    {    }} ``` Now I will use repository design pattern for all the curd operation. In repository we move all data access code into one place. Now I will create IRepository class in the models folder ``` using System;using System.Collections.Generic;using System.Linq;using System.Web;using TestSol.Models; namespace TestSol.Models{    public interface IRepository where T:class    {        IEnumerable SelectAll();        T SelectByID(object id);        void Insert(T obj);        void Update(T obj);        void Delete(object Id);    }} ``` This is an interface so for implementation we will create a class in the models folder and will implement this interface into that ``` using System;using System.Collections.Generic;using System.Linq;using System.Web;using TestSol.Models;using System.Data.Entity;using System.Data;  namespace TestSol.Models{    public class Repository:IRepository where T:class    {        private DemoEntities db = null;        private DbSet table = null;         public Repository()        {            this.db = new DemoEntities();            table = db.Set();        }          public Repository(DemoEntities db)        {            this.db = db;            table = db.Set();        }         public IEnumerable SelectAll()        {            return table.ToList();        }         public T SelectByID(object id)        {            return table.Find(id);        }         public void Insert(T obj)        {            table.Add(obj);            db.SaveChanges();        }         public void Update(T obj)        {            table.Attach(obj);            db.Entry(obj).State = EntityState.Modified;            db.SaveChanges();        }         public void Delete(object Id)        {            T existing = table.Find(Id);            table.Remove(existing);            db.SaveChanges();                    }     }}  ``` Add a new class in the models folder for setting the property for repository ``` using System;using System.Collections.Generic;using System.Linq;using System.Web; namespace TestSol.Models{    public class DML    {        public IRepository RegistrationForm        {            get            {                return new Repository();            }        }        public IRepository CountryList        {            get            {                return new Repository();            }        }    }}  ``` Now we will create unit of work for working with all the model classes. ``` using TestSol.Models;using System;using System.Collections.Generic;using System.Linq;using System.Web;using System.Web.Mvc; namespace TestSol.Controllers{    public class BaseController : Controller    {        //        // GET: /Base/         protected DML Uow { get; set; }        private DemoEntities db = null;        public BaseController()        {             Uow = new DML();        }     }}  ``` Now add a home controller and inherit base controller in it. In the home controller I have create add, edit, [delete](https://www.mindstick.com/forum/33620/how-to-delete-record-from-list-in-mvc-using-ajax) and Update action ``` using Newtonsoft.Json;using System;using System.Collections.Generic;using System.Linq;using System.Web;using System.Web.Mvc;using TestSol.Models; namespace TestSol.Controllers{    public class HomeController : BaseController    {        //        // GET: /Home/         public ActionResult index()        {             ViewBag.Users = Uow.RegistrationForm.SelectAll();            return View();        }        public ActionResult Add()        {            ViewBag.Country = Uow.CountryList.SelectAll();            return PartialView();        }         [AcceptVerbs(HttpVerbs.Post)]        public ActionResult Add(RegistrationForm model)        {                    if (ModelState.IsValid)            {                if (model.Id ==0)                {                    Uow.RegistrationForm.Insert(model);                 }                else                {                    var data = Uow.RegistrationForm.SelectByID(model.Id);                    if (data == null)                        Uow.RegistrationForm.Insert(model);                    else                        Uow.RegistrationForm.Update(model);                }            }            ViewBag.Users = Uow.RegistrationForm.SelectAll();            return PartialView("List");         }         public ActionResult Edit(int id)        {            ViewBag.Country = Uow.CountryList.SelectAll();            return PartialView("Add", Uow.RegistrationForm.SelectByID(id));        }        [HttpPost]        public ActionResult Delete(int id)        {            Uow.RegistrationForm.Delete(id);            ViewBag.users = Uow.RegistrationForm.SelectAll();            return PartialView("List");                   }         public ActionResult GetUser(string d)        {            if (!string.IsNullOrEmpty(d.Trim()))                ViewBag.Users = Uow.RegistrationForm.SelectAll().Where(x => d.Contains(x.FName) || d.Contains(x.LName) || d.Contains(x.Dob.ToString()) || d.Contains(x.City)).ToList();            else                ViewBag.Users = Uow.RegistrationForm.SelectAll().ToList();               return PartialView("List");        }        public ActionResult GetRecord()        {            ViewBag.Users = Uow.RegistrationForm.SelectAll();            return PartialView("UserList");        }       }}  ``` \ Our index view code in this I have added bootstrap library for better look and ajax validation ``` @model TestSol.Models.RegistrationForm@{    Layout = null;}                                                   Registration    
       
                   
       
           
                           
           
               
                   
                        
                                                    
                   
               
           
       
       
            @Html.Partial("List");       
   
      @using (Ajax.BeginForm("Add", "Home", new AjaxOptions    {        HttpMethod = "POST",        UpdateTargetId = "target",        OnSuccess = "updateSuccess",     }, new { id = "form1" }))    {            }               ``` our partial view list code is ```
                                                                                                                                                    @foreach (var d in ViewBag.Users as List)        {                                                                                                                                                                                                  }   
First Name            Middle Name            Last Name            DOB            Mobile            City            Pin             Address           
@d.FName@d.MName@d.LName@(d.Dob!=null?d.Dob.ToString("dd/MM/yyyy"):"")@d.Mobile@d.City@d.Pin@d.Address@Ajax.ActionLink("Edit", "Edit", new { Id = d.Id },                 new AjaxOptions                 {                     InsertionMode = InsertionMode.Replace,                     HttpMethod = "GET",                     OnSuccess = "fillUserdata"                 }) @Ajax.ActionLink("Delete", "Delete", new { Id = d.Id },                 new AjaxOptions                 {                     UpdateTargetId = "target",                     InsertionMode = InsertionMode.Replace,                     HttpMethod = "POST"                 })
 
  ``` When we run our program it will look like this. From search text box we can filter our records. ![How to Add Update Delete using entity framework](https://www.mindstick.com/mindstickforums/2be5b77d-fae0-4bde-8833-f8e2519af4c0/images/bdc5ae8d-88d6-4b56-8dd1-326d3c5e10b9.png) \ When we click add then it will open in modal pop up it will look like this and it is from Add Partial View ## And code for Add Partial ``` @model TestSol.Models.RegistrationForm 
    @Html.ValidationSummary(false)   
       
           
                           
            
                @Html.Label("Middle Name")
@Html.TextBoxFor(model => model.MName, new { @class = "form-control", placeholder = "Middle Name", title = "Enter Middle Name" })           
           
                @Html.Label("Last Name")
@Html.TextBoxFor(model => model.LName, new { @class = "form-control", placeholder = "Last Name", title = "Enter Last Name" })           
       
       
           
                @Html.Label("DOB")
                @Html.TextBoxFor(model => model.Dob, new { @class = "form-control ", id = "datepicker", placeholder = "Dob", title = "Enter DOB", @value = Model != null && Model.Dob != null ? Model.Dob.ToString("dd/MM/yyyy") : null })           
           
                @Html.Label("Mobile Number")
@Html.TextBoxFor(model => model.Mobile, new { @class = "form-control allownumber", placeholder = "Mobile", title = "Enter Mobile", @maxlength = "10" })           
           
                @Html.Label("City")
@Html.DropDownListFor(model => model.City, new SelectList(ViewBag.Country, "Country", "Country"),    "Select Category", new { @class = "form-control", placeholder = "City", title = "Enter City" })           
       
       
           
                @Html.Label("Pin")
@Html.TextBoxFor(model => model.Pin, new { @class = "form-control allownumber", placeholder = "Pin", title = "Enter Pin", @maxlength = "6" })@Html.ValidationMessageFor(model => model.Pin)           
           
                @Html.Label("Address")
@Html.TextAreaFor(model => model.Address, new { @class = "form-control", placeholder = "Address", title = "Enter Address" })           
       
    
 
   ``` \ ![How to Add Update Delete using entity framework](https://www.mindstick.com/mindstickforums/2be5b77d-fae0-4bde-8833-f8e2519af4c0/images/1e92e10c-9e10-4875-a916-dbc0c20fb8f4.png)\ \ When we click edit It will return partial Userlist in the pop up .Code for Userlist ```
                                                                                         @foreach (var d in ViewBag.Users as List)        {                                                                                                                  }   
First Name            Middle Name            Last Name            DOB            Mobile           
@d.FName@d.MName@d.LName@d.Mobile@Ajax.ActionLink("Select", "Edit", new { Id = d.Id },                 new AjaxOptions                 {                     InsertionMode = InsertionMode.Replace,                     HttpMethod = "GET",                     OnSuccess = "filldata"// <-- HTTP method                 })
   
``` Thank you.. --- Original Source: https://www.mindstick.com/forum/34255/how-to-add-update-delete-using-entity-framework Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.