Transactional Stored Procedure Call


Author
Message
Ertan Deniz
Ertan Deniz
StrataFrame User (165 reputation)StrataFrame User (165 reputation)StrataFrame User (165 reputation)StrataFrame User (165 reputation)StrataFrame User (165 reputation)StrataFrame User (165 reputation)StrataFrame User (165 reputation)StrataFrame User (165 reputation)StrataFrame User (165 reputation)
Group: Forum Members
Posts: 163, Visits: 493
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 ? 

Trent Taylor
Trent Taylor
StrataFrame Developer (8.7K reputation)StrataFrame Developer (8.7K reputation)StrataFrame Developer (8.7K reputation)StrataFrame Developer (8.7K reputation)StrataFrame Developer (8.7K reputation)StrataFrame Developer (8.7K reputation)StrataFrame Developer (8.7K reputation)StrataFrame Developer (8.7K reputation)StrataFrame Developer (8.7K reputation)
Group: StrataFrame Developers
Posts: 6.6K, Visits: 6.9K
You will just want to use the ExecuteNonQuery on the data source:

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

GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...




Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search