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)).
Now I will create TestDB.edmx out of this database.
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!!!