[Karel Kral]

Hello, I am very satisfied user of LINQPad. I am using it instead of MS Management Studio for all select queries. I works as charm.

But is there any posibility how to delete or update data from LINQ query from LINQPad? I just tried obvious LINQ syntax from C# but I'm in stuck - I cannot find way how to accomplish this.

Can You suggest me any way?

[JoeAlbahari]

Hi Karel

Here's how to insert, update and delete a customer using the sample database in LINQPad:

CODE

Customer cust = new Customer { ID=1000, Name="Bloggs" };
Customers.InsertOnSubmit (cust);
SubmitChanges();

Customers.Dump ("After inserting");

cust.Name = "Bloggs2";
SubmitChanges();                 // Updates the customer

Customers.Dump ("After updating");

Customers.DeleteOnSubmit (cust);
SubmitChanges();                 // Deletes the customer

Customers.Dump ("After deleting");

Regards

Joe