Problem with transaction

Hi ,

While using transactions in service layer as follows

TransactionManager tran = new TransactionManager(DataRepository.ConnectionStrings["XXX"].ConnectionString);

tran = ConnectionScope.ValidateOrCreateTransaction();

try{

Insert 1

insert 2

tran.commit();

}

catch(exception)

{tran.rollback();} 

In this it states that a transaction has not been started.

if i do use tran.begintranasction after the validateorcreatetranasction it states that the tranasaction already exists.

As a result I am not able to commit or roll back.

am i missing any thing in this?

thanks in advance for any help.

You would something along the lines of:
TransactionManager tm = null;
try
{
    tm = ConnectionScope.ValidateOrCreateTransaction(true);
    // or use ConnectionScope.CreateTransaction() if u prefer
    order.save();
    customer.save();
    tm.Commit();
}
catch (Exception ex)
{
    tm.Rollback();
}

You would not create another transaction manager, this is done by the provider.

How do I do a transaction through Service Layer?