No I am not I am doing something like this
Re: ado.net transactions
Posted: 02-14-2005 10:04 AM
using (SqlConnection connection = new SqlConnection(ConnectionString))
{
connection.Open();
using (SqlTransaction transaction = connection.BeginTransaction())
{
try
{
using (INASBAL.Service service = new INASBAL.Service())
{
service.SequenceID = service.InputAccountData(transaction, ref dt);
ParseAndInsertAccountLeadType(transaction, ref dt, nav, service);
ParseAndInsertAccountDisabilityCoverage(transaction, ref dt, nav, service);
ParseAndInsertAccountAuthorizedRider(transaction, ref dt, nav, service);
ParseAndInsertMailingAddress(transaction, ref dt, nav, service);
ParseAndInsertAccountAgent(transaction, ref dt, nav, service);
ParseAndInsertAccountAuthorizingOfficer(transaction, ref dt, nav, service);
ParseAndInsertAccountBillingContact(transaction, ref dt, nav, service);
ParseAndInsertAccountBroker(transaction, ref dt, nav, service);
ParseAndInsertAccountFlexOneBenefit(transaction, ref dt, nav, service);
ParseAndInsertAccountLegalRep(transaction, ref dt, nav, service);
ParseAndInsertAccountContactFsa(transaction, ref dt, nav, service);
ParseAndInsertAccountFlexIneligibleBen(transaction, ref dt, nav, service);
ParseAndInsertAccountOtherCarrierBen(transaction, ref dt, nav, service);
//
//if all successful commit transaction
//
transaction.Commit();
}//using service
}//try
catch (Exception ex)
{
transaction.Rollback();
throw ex;
}
}//using transaction
}//using connection
INSIDE THESE METHODS I AM USING MS DATA APPLICATION BLOCK LIKE
Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(transaction,
CommandType.StoredProcedure, strProcedure, arParms);
Thanks
Ajit
Miha Markic said:
i guess you are invoking begintransaction too many times?
--
Miha Markic [MVP C#] - RightHand .NET consulting & development
www.rthand.com
SLODUG - Slovene Developer Users Group
www.codezone-si.info
ajit said:
I am getting this erroor on transaction.commit
"stack overflow"
on transaction.rollback i am getting this
{"This SqlTransaction has completed; it is no longer usable." }
I am passing same transaction object to lot of methods like say 12
which call stored procedures
how to overcome this problem.
I dont want to use com+
Thanks
Ajit
