Linq Transaction

System.Data.Common.DbTransaction trans = null;

var objDataClass= new DataClassesUdescDataContext();

 

try {

dc.Connection.Open();

trans = dc.Connection.BeginTransaction();

dc.Transaction = trans;

//...

trans.Commit();}

catch

{

if (trans != null) trans.Rollback();

}

finally

{

// Close the connection                    

if (objDataClass.Connection.State == ConnectionState.Open)

objDataClass.Connection.Close();

}