[Firebird-net-provider] Enlisting transaction
Hi *,
I've found behavior, that's probably not right (but I don't have MS
SQL near my hands right now, so just guess). Imagine you have:
this.bARTableAdapter.Fill(this.dsDemo.BAR);
this.fOOTableAdapter.Fill(this.dsDemo.FOO);
in some method and connection string
data source=localhost;initial catalog=someDB;user
id=SYSDBA;password=masterkey;enlist=false
With this, everything works fine. Now change the enlist=false to
enlist=true.The filling stopped working. OK, I added TransactionScope
around all two .Fill commands. But only first was sucesfull and
DataSet has been filled, the second not. When you add TransactionScope
block around every .Fill command everything works fine. :o
Is this expected? Or should I look for the problem root cause?
PS: I've also test update in TransactionScope block and seems to be
working fine (as I expect).
--
Jiri {x2} Cincura (Microsoft Student Partner)
http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com
-
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2005.
http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Enlisting transaction
Hello: With this, everything works fine. Now change the enlist=false to enlist=true.The filling stopped working. OK, I added TransactionScope around all two .Fill commands. But only first was sucesfull and DataSet has been filled, the second not. When you add TransactionScope block around every .Fill command everything works fine. :o Both inside the same TransactionScope -- Carlos Guzmán Álvarez Vigo-Spain Blog: http://carlosga.wordpress.com/ FirebirdClient : http://www.firebirdsql.org/ XMPP Client : http://code.google.com/p/xmppclient/ ohloh : http://www.ohloh.net/accounts/4138 - This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2005. http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Enlisting transaction
On 9/25/07, Carlos Guzmán Álvarez [EMAIL PROTECTED] wrote:
Both inside the same TransactionScope
Both inside same not working. Only first .Fill fills datatable. Second
is empty. It's probably not expected. :)
BTW when I not use TransactionScope block but in connection string is
enlist=true should this work?
--
Jiri {x2} Cincura (Microsoft Student Partner)
http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com
-
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2005.
http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
