[Firebird-net-provider] Enlisting transaction

2007-09-25 Thread Jiri Cincura
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

Re: [Firebird-net-provider] Enlisting transaction

2007-09-25 Thread Carlos Guzmán Álvarez
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

Re: [Firebird-net-provider] Enlisting transaction

2007-09-25 Thread Jiri Cincura
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