StrataFrame Forum

Transactional Stored Procedure Call

http://forum.strataframe.net/Topic15978.aspx

By Ertan Deniz - 4/29/2008

As an example, I have a method implemented with an SP with some business logic inside. (XOperations.UpdateX)

And I need to call this method as a part of a transaction.

BeginTransaction ;

Object1.Save ;

Xoperations.UpdateX;

Object2.Save;

Commit;

I've found that DbSourceItem.ExecuteNonQuery method has a transactional parameters.

Should I use DbSourceItem.ExecuteNonQuery  method ? Or anything else ? 

By Trent L. Taylor - 4/29/2008

You will just want to use the ExecuteNonQuery on the data source:

MicroFour.StrataFrame.Data.DataBasics.DataSources("").ExecuteNonQuery(MyCommand,True,"TranKey")