Hello:
> So, I'm testing 5 cases per second and seems to be, that I'm little
> bit confused with TransactionScope and no result. :)
>
I'm reading this today, sorry for the delay ... i'm a bit busy this times :)
> To clarify things I'll do some summary. Focused on some basic ADO.NET
> classes. If
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 F
Hello:
> MS SQL behaves completely different. With this new info, seems to be
> this correct behavior.
The problem here is how i'm handling enlistement when closing the connection.
The sql client will be hanlding this correctly for sure :)
The first fill will be opening the connection and closi
> 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
---
Oh man. I think I've found the problem. The connection inside
TableAdapter must be opened manually (no matter whether first's
TableAdapter or second's).
I'll check hoe the MS SQL behaves.
--
Jiri {x2} Cincura (Microsoft Student Partner)
http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com
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 (Micros
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
(x86)\Firebird\Firebird_2_1\examples\empbuild\employee.fdb;UserID=SYSDBA;Password
On 9/26/07, Carlos Guzmán Álvarez <[EMAIL PROTECTED]> wrote:
> > BTW when I not use TransactionScope block but in connection string is
> > enlist=true should this work?
> >
> No
Just info. In MS SQL I have connection string like "Data
Source=.\sqlexpress;Initial Catalog=testovaci;Integrated
Securi
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 s
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 wh
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-
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 sh
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
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
On 7/19/07, Carlos Guzmán Álvarez <[EMAIL PROTECTED]> wrote:
> 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.
OK.
--
Jiri
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 co
I have the exact same problem. Please post whatever findings you two make!
Regards, Jon.
On 5/18/07, Jiri Cincura <[EMAIL PROTECTED]> wrote:
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?
>
> O
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} Cincu
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 - th
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 SqlConnection(@"D
21 matches
Mail list logo