Melick's Blog

Open a new Visual Studio windows application project (c#) Right click the project and goto AddNew item . and it will popup the following dialog. select the Linq to SQL Classes and give a neme add click add. then double click the added class in your solution explorer. Then it will load following type of screen. In the Data connection (Assumme you already created a SQL Server Database and also a table nemed "Table1"), Drag and drop the table to the window. Then it will ask for connection string saving dialog. For the moment keep it NO. Now we will see how to use LINQ to do Insert , Update , Delete. Coding is describing below. ( sample is the name given by me to the LinqtoSQL class). private void cmdAdd_Click( object sender, EventArgs e) { sampleDataContext Dt = new sampleDataContext(); Table1 T = new Table1(); T.Address = "Address 1" ; T.Name = "a" ;   Dt.Table1s.InsertOnSubmit(T); Dt.SubmitChanges();