Wriju's BLOG

.NET, Cloud and everything

ADO.NET Entity: Insert Update and Delete


For small blogs, it requires more references and explanation, which sometimes are redundant. So I thought of writing single blog which is combination of topics more or less related to one thing.


 


I am exploring ADO.NET Entity Framework and have been trying things out there. Here I am planning to demonstrate how to do insert, update and delete.


 


Here I will use a database created by me. In the Emp table there are two columns Id (Primary and auto-generated) and Name (simple varchar(50)).



image



Now I will create TestDB.edmx out of this database.


image



Insert


 


using (TestDBEntities ctx = new TestDBEntities())


{


    //Create new Emp object


    Emp e = new Emp() { Name = “Test Employee” };


 


    //Add to memory


    ctx.AddToEmp(e);


 


    //Save to database


    ctx.SaveChanges();


}


 


 


Update


 


using (TestDBEntities ctx = new TestDBEntities())


{


    //Get the specific employee from Database


    Emp e = (from e1 in ctx.Emp


             where e1.Name == “Test Employee”


             select e1).First();


 


    //Change the Employee Name in memory


    e.Name = “Changed Name”;


 


    //Save to database


    ctx.SaveChanges();


}


 


Delete


 


using (TestDBEntities ctx = new TestDBEntities())


{


    //Get the specific employee from Database


    Emp e = (from e1 in ctx.Emp


             where e1.Name == “Test Employee”


             select e1).First();


 


    //Delete it from memory


    ctx.DeleteObject(e);


 


    //Save to database


    ctx.SaveChanges();


}


 


In my next post I will write about “how to handle CRUD with Relationship”.



Namoskar!!!