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.