If you're using .NET 2.0 you have the option of using TransactionScope.
Although this can have a performance hit.
The other option is to use transaction directly by extending your table
adapter with a BeginTransaction method. The method should first check that
the current connection is open. Then create a transaction from the adapters
Connection property and assign it to each command (I,U,D) and the
_commandCollection. Remember to check for nulls! Then return the
transaction. It's not a lot of work, honest.
I'd also recommend you take a look at ODP.NET. It's brimming with neat
stuff and the documenation is superb, all 1212 pages of it!
http://www.oracle.com/technology/tec...net/index.html
HTH
Glenn
"maltobelli" <ma********@discussions.microsoft.comwrote in message
news:A6**********************************@microsof t.com...
>I am building a windows forms app using VS2005 and the dataset designer to
connect to an Oracle backend. So far this has worked quickly and easily
for
me to finish the app within the given timeframe.
I would love to add transactioning to some of the calls to add robustness.
I can begin the transaction on the tableadapter, but I cannot find a way
to
enlist the various predefined commands for each tableadapter into the
transaction. Or do the commands automatically enlist themselves in the
transaction with a System.Data.OracleClient type connection?
Thanks in advance for any information.