事务处理

private void TransAdd()
{
DataClasses1DataContext db = new DataClasses1DataContext(sqlconStr);
if (db.Connection != null) db.Connection.Open();
DbTransaction tran = db.Connection.BeginTransaction();
db.Transaction = tran;
try
{
student mystudent = new student();
mystudent.StudentName = “LiX”;
mystudent.Sex = “Man”;
mystudent.Old = 17;
Oclass myClass = new Oclass();
myClass.StudentName = “LiX”;
myClass.Class = “Win7”;
db.ObjectTrackingEnabled = true;
db.student.InsertOnSubmit(mystudent);
db.Oclass.InsertOnSubmit(myClass);
db.SubmitChanges();
tran.Commit();
}
catch(Exception ex)
{
tran.Rollback();
}
}