C#

CustomersTableAdapter tableAdap = new CustomersTableAdapter() ;
SqlTransaction tableAdapTran = null ;
SqlConnection tableAdapConn = null ;

try
{
    tableAdapConn = tableAdap.OpenConnection() ;
    tableAdapTran = tableAdapConn.BeginTransaction() ;

    // Do your transactional work

    tableAdapTran.Commit() ;
}
catch (Exception)
{
    tableAdapTran.Rollback() ;
}
finally
{
    tableAdapConn.Close() ;
}

CustomersTableAdapter tableAdap = new CustomersTableAdapter() ;
SqlTransaction tableAdapTran = null;
SqlConnection tableAdapConn = null;

OrdersTableAdapter ordersAdapter = new OrdersTableAdapter();
SqlTransaction ordersAdapterTran = null;
SqlConnection ordersAdapterConn = null;

try
{
    tableAdapConn = tableAdap.OpenConnection();
    tableAdapTran = tableAdapConn.BeginTransaction();

    ordersAdapterConn = ordersAdapter.OpenConnection();
    ordersAdapterTran = ordersAdapterConn.BeginTransaction();


    // What i must write here ?


    tableAdapTran.Commit();
}
catch (Exception)
{
    tableAdapTran.Rollback();
}
finally
{
    tableAdapConn.Close();
}

Could not load type 'RCH.BL.EMR.PatientEmergencyContacts" from assembly 'BL, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null"

<br />
//governorates<br />
Governorates = new RCH.BL.Asclepius.JordanGovernorates().GetAllFromDB();<br />
//nationality<br />
PatientNationality = new RCH.BL.Asclepius.Nationality().GetAllFromDB();<br />
//NumberFormats<br />
NumberFormats = new RCH.BL.Asclepius.NumberFormat().GetAllFromDB();<br />
//Contact Information Type<br />
InformationType = new RCH.BL.Asclepius.ContactInformationType().GetAllFromDB();<br />
//rate of stay<br />
PatientRateOfStay = new RCH.BL.Accounting.RateOfStay().GetAllFromDB();<br />
//Emergency Contacts<br />
EmergencyContactsBL = new RCH.BL.EMR.PatientEmergencyContacts();//this is the one that's causing the gates of hell to open and unleash the demons<br />