OleDbTransaction is the only class that describes Begin() as being nested. I would assume from that that only OleDbConnection supports nested transactions; but, I don't know if that includes OleDbConnection.BeginTransaction(). There's no mention whether it calls OleDbTransaction.Begin(). Reflecting OleDbConnection.BeginTransaction() shows that it calls OleDbTransaction.InternalBegin() in the same was as OleDbTransaction.Begin() does; so, it would appear OleDbConnection.BeginTransaction() supports nesting.
Should be simple to test. What connection class are you using? On Wed, 4 Jan 2006 13:47:25 -0600, Franklin Gray <[EMAIL PROTECTED]> wrote: >Can ado.net 1.1 support nested transactions? I would like to have the >ability to rollback all changes at the end but also have a start and >commit trans in the loop. Note: this is not the exact logic but a simple >example to demonstrate what I want to accomplish so please don't ask why >because that's too hard to explain. > >IE >Start trans > >begin loop > start trans > do work > commit trans >end loop >commit trans (or rollback depending on business rule) =================================== This list is hosted by DevelopMentor® http://www.develop.com View archives and manage your subscription(s) at http://discuss.develop.com
