In this example you will see how to insert record in database using linq. Create a DataClasses.dbml file. Open DataClasses.dbml file. Open Server Explorer and connect to database. Expand Tables node and drag and drop your table. I have used Patient table in my database. The following code will add new patient record into patient table in SQL Server.
using (var db = new DataClassesDataContext())
{
var addPat = new PATIENT { NAME = "Aamir Hasan" };
db.PATIENTs.InsertOnSubmit(addPat);
db.SubmitChanges();
}
Note: Table should have primary key, otherwise it will through invalid operation exception.