Part 2 Insert Update Delete using LINQ to SQL
Text version of the video
http://csharp-video-tutorials.blogspo...
Healthy diet is very important both for the body and mind. If you like Aarvi Kitchen recipes, please support by sharing, subscribing and liking our YouTube channel. Hope you can help.
/ @aarvikitchen5572
Slides
http://csharp-video-tutorials.blogspo...
LINQ to SQL Tutorial - All Text Articles & Slides
http://csharp-video-tutorials.blogspo...
LINQ to SQL Tutorial Playlist
• LINQ to SQL Tutorial
Dot Net, SQL, Angular, JavaScript, jQuery and Bootstrap complete courses
https://www.youtube.com/user/kudvenka...
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();
}
Sur cette page du site, vous pouvez voir la vidéo en ligne Part 2 Insert Update Delete using LINQ to SQL durée heure minute seconde en bonne qualité , qui a été Téléchargé par l'utilisateur kudvenkat 04 septembre 2014, Partagez le lien avec vos amis et connaissances, sur youtube cette vidéo a déjà été regardée 116,925 fois et il a aimé 399 téléspectateurs. Bon visionnage!
