I'll check hoe the MS SQL behaves.
MS SQL behaves completely different. With this new info, seems to be
this correct behavior.
--
Jiri {x2} Cincura (Microsoft Student Partner)
http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com
So, I'm testing 5 cases per second and seems to be, that I'm little
bit confused with TransactionScope and no result. :)
To clarify things I'll do some summary. Focused on some basic ADO.NET
classes. If you're writing some objects, that will later bind to so
visual components you'll probably use
Hello:
Is this something like what you are doing ??
using (TransactionScope scope = new TransactionScope())
{
using (FbConnection connection = new
FbConnection(@DataSource=localhost;Database=C:\Program Files
On 10/8/07, Carlos Guzmán Álvarez [EMAIL PROTECTED] wrote:
Hello:
Is this something like what you are doing ??
I have generated DataSet and TableAdapter from DataSet Designer. But
yes. In basic this is what I'm doing. Two TableAdapters in one
TransactionScope.
--
Jiri {x2} Cincura (Microsoft
Hello:
So it's bug, right? If I'll find some time, I'll look at it too.
Yes, i think it's a bug.
Is this described on some page? I hate surrounding every DB stuff with
TransactionScope only 'cause I need on some places TransactionScope to
work. If this is really expected, it's not good step
Hello:
Both inside same not working. Only first .Fill fills datatable. Second
is empty. It's probably not expected. :)
I will check it on Friday
BTW when I not use TransactionScope block but in connection string is
enlist=true should this work?
No
--
Carlos Guzmán Álvarez
Vigo-Spain
On 9/26/07, Carlos Guzmán Álvarez [EMAIL PROTECTED] wrote:
Hello:
Both inside same not working. Only first .Fill fills datatable. Second
is empty. It's probably not expected. :)
I will check it on Friday
So it's bug, right? If I'll find some time, I'll look at it too.
BTW when I not
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
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
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
Hello:
it's liitle bit old problem, but ...
It's now working. Did you commit any changes? If so, I must miss it. :)
If i remember well yes, and i have some more pending that i should do in
2.5.0 first.
-
This SF.net
On 5/18/07, Carlos Guzmán Álvarez [EMAIL PROTECTED] wrote:
Hello:
But on FB it inserts record no matter that no call of Complete method
was done. Did I miss something?
Ok i will try to review it later.
Hi Carlos,
it's liitle bit old problem, but ...
It's now working. Did you commit any
Hello:
But on FB it inserts record no matter that no call of Complete method
was done. Did I miss something?
Ok i will try to review it later.
-
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the
Carlos Guzmán Álvarez wrote:
Hello:
But on FB it inserts record no matter that no call of Complete method
was done. Did I miss something?
Ok i will try to review it later.
I'll look at this too. I was just asking to be sure that I'm not doing
something wrong.
--
Jiri {x2} Cincura
Hello,
this code works on MS SQL (returns always 0 (table was empty)):
using (TransactionScope ts = new TransactionScope())
{
InsertTestMS();
//ts.Complete();
}
Console.WriteLine(SelectTestMS());
private static int SelectTestMS()
{
using (SqlConnection conn = new
15 matches
Mail list logo
