Transactional Stored Procedure Call
 
Home My Account Forum Try It! Buy It!
About Contact Us Site Map
StrataFrame Forum
Home      Members   Calendar   Who's On
Welcome Guest ( Login | Register )
      



Transactional Stored Procedure CallExpand / Collapse
Author
Message
Posted 04/29/2008 8:19:00 AM
StrataFrame Novice

StrataFrame NoviceStrataFrame NoviceStrataFrame NoviceStrataFrame NoviceStrataFrame NoviceStrataFrame NoviceStrataFrame NoviceStrataFrame Novice

Group: StrataFrame Users
Last Login: Today @ 1:44:09 AM
Posts: 115, Visits: 344
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 ? 

Post #15978
Posted 04/29/2008 10:38:21 AM


StrataFrame Developer

StrataFrame Developer

Group: StrataFrame Developers
Last Login: Today @ 11:54:01 AM
Posts: 4,104, Visits: 4,177
You will just want to use the ExecuteNonQuery on the data source:

MicroFour.StrataFrame.Data.DataBasics.DataSources("").ExecuteNonQuery(MyCommand,True,"TranKey")
Post #15983
« Prev Topic | Next Topic »


Reading This TopicExpand / Collapse
Active Users: 0 (0 guests, 0 members, 0 anonymous members)
No members currently viewing this topic.
Forum Moderators: Ben Chase, Trent L. Taylor, Steve L. Taylor

PermissionsExpand / Collapse

All times are GMT -6:00, Time now is 7:45pm

Powered By InstantForum.NET v4.1.4 © 2008
Execution: 0.047. 12 queries. Compression Enabled.
Site Map - Home - My Account - Forum - About Us - Contact Us - Try It - Buy It

Microsoft, Visual Studio, and the Visual Studio logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.