Re: Transaction

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: 
> firebird-net-provider-bounces-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@xxxxxxxxxxxxxxxx
> [mailto:firebird-net-provider-bounces-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@xxxxxxxxxxxxxxxx]
>  On Behalf Of
> Jun S. Pomer
> Sent: Monday, 18 September 2006 2:15 pm
> To: firebird-net-provider-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@xxxxxxxxxxxxxxxx
> 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"" <jspomer-4S+unTJIJHOSIePB9oIZ0w@xxxxxxxxxxxxxxxx> wrote in 
> message
> news:eeefqv$os0$1@xxxxxxxxxxxxxxxxx
> > Hi Carlos,
> >
> > Thanks for the reply.
> >
> > What is recommended, or alternative to use a transaction?
> >
> > Thanks.
> >
> > Jun
> >
> > "Carlos Guzman Alvarez" 
> > <carlos.guzman-OMCZoIAgfAtBDgjK7y7TUQ@xxxxxxxxxxxxxxxx> wrote in message
> > news:450AB5E6.2060603-OMCZoIAgfAuaVBYCxK7ZJA@xxxxxxxxxxxxxxxx
> > > 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
> > > Firebird-net-provider-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@xxxxxxxxxxxxxxxx
> > > 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
> > Firebird-net-provider-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@xxxxxxxxxxxxxxxx
> > 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