(LINQ Learning Series) (8) Examples of the LINQ Tutorial: Transaction Processing

LINQ to SQLBy default, a transaction is created when an update is submitted. If some modifications are incorrect, other modifications will not take effect.

 

Insert2Data in tables for Transaction Processing

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 ();
}
}