Wriju's BLOG

.NET, Cloud and everything

LINQ to SQL : Update data through Object Model

LINQ to SQL support updating data through object. Continuing with my previous blog on INSERT, let me discuss about the update method


static void Main(string[] args)


    string strConnection = @”Connection String”;


    TestDB db = new TestDB(strConnection);


    //Here I am finding the employee with Id 19

    var updateQ = db.Emps.First(e => e.Id == 19);


    //Then I will modify that employee name and give new name

    updateQ.Name = “Updated Employee”;


    //Commit the changes to database

    //at this point DML gets generated



    //To view the updated data




All the methods are coming from DataContext class (responsible for SQL query generation). The above method converts the object addition to DML query.