Even were it possible to do it the way you've written, I would avoid doing it like that anyway.
The reason is that because the TableAdapter calls will create one connection each to the database, the TransactionScope call will promote the transaction from the location transaction manager to MS DTC, which would be incur a pretty hefty performance penalty. All in all, the transaction support for TableAdapters are pretty lame. This page contains some basic information on how to get TableAdapters to work with transactions: http://blah.winsmarts.com/2006/06/18/the-definitive-tableadapters--transacti ons-blog-post.aspx Dean. > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > Jun S. Pomer > Sent: Monday, 18 September 2006 2:15 pm > To: [email protected] > Subject: Re: [Firebird-net-provider] Transaction > > Hi, > > Anybody can point me where is the right direction? I need the > "transaction" > to update multiple tables. > > Thanks in advance. > > Jun > > > ""Jun S. Pomer"" <[EMAIL PROTECTED]> wrote in message > news:[EMAIL PROTECTED] > > Hi Carlos, > > > > Thanks for the reply. > > > > What is recommended, or alternative to use a transaction? > > > > Thanks. > > > > Jun > > > > "Carlos Guzman Alvarez" <[EMAIL PROTECTED]> wrote in message > > news:[EMAIL PROTECTED] > > > Hello: > > > > Hi Carlos, > > > > > > > > I so sorry, for very late reply. Anyway below is the sample > transaction > > > > based. Is it safe/compatible using Firebird provider? > > > No, there are no support for TransactionScope for now in the provider. > > > > > > > > > -- = > > > > > > Carlos Guzm=E1n =C1lvarez > > > Vigo-Spain > > > > > > > ------------------------------------------------------------------------ > - > > > Using Tomcat but need to do more? Need to support web services, > security? > > > Get stuff done quickly with pre-integrated technology to make your job > > easi= > > > er > > > Download IBM WebSphere Application Server v.1.0.1 based on Apache > Geronimo > > > > > > http://sel.as- > us.falkag.net/sel?cmd=3Dlnk&kid=3D120709&bid=3D263057&dat=3D1= > > > 21642 > > > _______________________________________________ > > > Firebird-net-provider mailing list > > > [email protected] > > > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider > > > > > > > > > > > > > > -------------------------------------------------------------------------- > -- > ---- > > > > ------------------------------------------------------------------------ > - > > Using Tomcat but need to do more? Need to support web services, security? > > Get stuff done quickly with pre-integrated technology to make your job > easier > > Download IBM WebSphere Application Server v.1.0.1 based on Apache > Geronimo > > http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 > > > -------------------------------------------------------------------------- > -- > ---- > > > > _______________________________________________ > > Firebird-net-provider mailing list > > [email protected] > > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider > > > > ------------------------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ Firebird-net-provider mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
