Manipulate data with LINQ to SQL

1_ Create LINQ datacontext from Visual Studio

2_ Create LINQ datacontext from command line

3_ Query data (person table)

C#
var people = from p in db.persons
              where p.department_id > 0 &&  p.height>1
              orderby p.lastName
              select new
              {
                  p.firstName,
                  p.lastName,
              };

4_ Update data (person)

C#
var person = (from p in db.persons select p).FirstOrDefault();  // select the record that you want to update
person.lastName = "Cernin";  // make the update in memory
db.SubmitChanges();  // propagate changes back to database

5_ Insert data (person)

C#
person newP = new person();
newP.firstName = "John";
newP.height = 189;

db.persons.InsertOnSubmit(newP);  
db.SubmitChanges();

6_ Delete data (person)

C#
var personsToDelete = db.persons.Where(inst => inst.lastName == "Third");  // select who should be deleted
db.persons.DeleteOnSubmit(personsToDelete.First());  // execute the delete in memory  
db.SubmitChanges();  // propagate changes back to database