51,425 views 139 on YTPak
135 1

Published on 05 Sep 2014 | over 2 years ago

Link for all dot net and sql server video tutorial playlists
www.youtube.com/user/kudvenkat/playlists

Link for slides, code samples and text version of the video
csharp-video-tutorials.blogspot.com/2014/09/part-2-insert-update-delete-using-linq.html

In this video, we will discuss performing Insert Update and Delete using LINQ to SQL. We will continue with the example, we worked with in Part 1. In Part 1, we discussed performing a Select using LINQ to SQL. Please watch Part 1 before proceeding.

Insert using LINQ to SQL
using (SampleDataContext dbContext = new SampleDataContext())
{
Employee newEmployee = new Employee
{
FirstName = "Tim",
LastName = "T",
Gender = "Male",
DepartmentId = 1,
Salary = 55000
};

dbContext.Employees.InsertOnSubmit(newEmployee);
dbContext.SubmitChanges();
}

Update using LINQ to SQL
using (SampleDataContext dbContext = new SampleDataContext())
{
Employee employee = dbContext.Employees.SingleOrDefault(x =] x.ID == 8);

employee.Salary = 65000;

dbContext.SubmitChanges();
}

Delete using LINQ to SQL
using (SampleDataContext dbContext = new SampleDataContext())
{
Employee employee = dbContext.Employees.SingleOrDefault(x =] x.ID == 8);
dbContext.Employees.DeleteOnSubmit(employee);
dbContext.SubmitChanges();
}

Loading related videos...