Transactional Stored Procedure Call

Ertan Deniz — Tue, 29 Apr 2008 10:38:21 GMT

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 ?

RE: Transactional Stored Procedure Call

Trent L. Taylor — Tue, 29 Apr 2008 10:38:21 GMT

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

[codesnippet]MicroFour.StrataFrame.Data.DataBasics.DataSources("").ExecuteNonQuery(MyCommand,True,"TranKey")[/codesnippet]