Print Page | Close Window

How to user transactions

Printed From: IdeaBlade
Category: DevForce
Forum Name: DevForce Classic
Forum Discription: For .NET 2.0
URL: http://www.ideablade.com/forum/forum_posts.asp?TID=1021
Printed Date: 23-Apr-2025 at 10:20pm


Topic: How to user transactions
Posted By: vinothvdp
Subject: How to user transactions
Date Posted: 13-Dec-2008 at 12:23am
Hello sir,
 
How to use begin ,Commit and rollback transactions.can u give me some example.
 
Thank you.


Replies:
Posted By: davidklitzke
Date Posted: 18-Dec-2008 at 1:16pm

Here is how you can do two saves in one transaction:.

(1)        You must use Microsoft Distributed Transaction Coordinator (DTC)

(2)        Start a Transaction (e.g., using (TransactionScope scope = new TransactionScope()

(3)        Do the first SaveChanges using a Transactional Save

(4)        Do the second SaveChanges using a Transactional Save

(5)        If both saves are successful, commit the Transaction (e.g., scope.Complete();

Posted By: vinothvdp
Date Posted: 18-May-2009 at 6:03am

Hi,

i tried below code but i am getting "Save failed - Cannot start more transactions on this session."

could you please assist me.

 

using (TransactionScope scope = new TransactionScope())

{

try

{

SaveOptions mSaveOptions = new SaveOptions();

mSaveOptions.IsTransactional = true;

pm.SaveChanges(mSaveOptions);

scope.Complete();

MessageBox.Show("Sucess");

}

catch (PersistenceManagerSaveException ex)

{

MessageBox.Show(ex.Message.ToString());

}

finally

{

//scope.Dispose();

}

}

 

Thank you,

Vinoth

Posted By: davidklitzke
Date Posted: 18-May-2009 at 8:51am
I tried your code on my machine and did not receive this error.
 
This error occurs in certain situations when you have a nested transaction.
 
I suggest searching the Internet for "Cannot start more transactions on this session".  You will find a good number of matches.


Print Page | Close Window