Transaction Commit And Rollback in LINQ

How to Use transaction.

When we want to save data to multiple table or in multiple time in a table use transaction.

follow code snip below. 

Class Abc {

//Object Declaration

ProjectRepository pr = new ProjectRepository();

DBDataContext DBObject = new DBDataContext();

//Action

public ActionResult FormEntry(FormCollection fc)

{

  System.Data.Common.DbTransaction Tran=null;

  DBObject.Connection.Open();

  Tran = DBObject.Connection.BeginTransaction();

  DBObject.Transaction = Tran;

           

 try

 {

       //---Code of insert or Update---

               DataTable dtc = (DataTable)SessionBag.Current.ChequeDetailsXV;

               if (dtc.Rows.Count > 0)

                    {

                        foreach (DataRow dr in dtc.Rows)

                        {

                            CapitalDetail Pc = new CapitalDetail();

                            Pc.PrGroup_ID = Convert.ToInt32(dr["PrGroup_ID"]);

                            Pc.Capi_Amount = Convert.ToInt32(dr["Amount"]);

                            Pc.Capi_Bank = Convert.ToString(dr["ChqBankBranch"]);

                            Pc.Capi_Bank_Branch = Convert.ToString(dr["ChqBankBranch"]);

                            //Pc.Capi_OutStation = Convert.ToString(dr["DrawNo"]);

                            Pc.Capi_ChequeNo = Convert.ToInt32(dr["ChqNo"]);

                            Pc.Capi_Date = Convert.ToDateTime(dr["ChqDate"]);

                            Pc.Capi_EntryDate = Convert.ToDateTime(DateTime.Now);

                            Pc.Capi_Type = Convert.ToString("Cheque");

                           

                            pr.Add(Pc);

                        }

                    }

        pr.Save();

        Tran.Commit();

 }

catch (Exception ex)

 {

        Tran.Rollback();

 }

finally

{

if (DBObject.Connection != null && DBObject.Connection.State ==                                                                                                                      System.Data.ConnectionState.Open)

       {

           DBObject.Connection.Close();

                       

       }

     

}

}