StrataFrame Forum » StrataFrame Application Framework - V1 » Business Objects and Data Access (How do I?) » ExecuteNonQuery() and Transactions

ExecuteNonQuery() and Transactions

choyt — Fri, 21 Sep 2007 13:21:30 GMT

Hi Folks

Will the below ExecuteNonQuery run as part of the transaction?

[codesnippet]

TransactionBegin("", Data.IsolationLevel.RepeatableRead)

ExecuteNonQuery(c)

Something.Save(True)

TransactionCommit("")

[/codesnippet]

RE: ExecuteNonQuery() and Transactions

StrataFrame Team — Fri, 21 Sep 2007 13:21:30 GMT

Good to hear. Also, if you need access to the raw SqlTransaction object, you can access it through the Transactions property on the SqlDataSourceItem. Just give it the key, and it will return the SqlTransaction object; just in case you need to do anything with it.

RE: ExecuteNonQuery() and Transactions

choyt — Fri, 21 Sep 2007 09:43:12 GMT

Works for me! Thanks!

RE: ExecuteNonQuery() and Transactions

StrataFrame Team — Thu, 20 Sep 2007 09:04:07 GMT

Um, no, it won't, there isn't a wrapper method on the BO for that... It needs to be added.

In the meantime, you can do so through the DbDataSourceItem directly. So, in the BO:

DbCommand c = SomeCommand
DataBasics.DataSources("key").ExecuteNonQuery(c, True, "TranKey")