Re: [Firebird-net-provider] TransactionScope with EntityFramework 4

O.k. I think I need to chance all my data layer :s Thanks for all Mr Jiri :D -- View this message in context: http://firebird.1100200.n4.nabble.com/TransactionScope-with-EntityFramework-4-tp3780144p3782521.html Sent from the firebird-net-provider mailing list archive at Nabble.com.

Re: [Firebird-net-provider] TransactionScope with EntityFramework 4

On Wed, Aug 31, 2011 at 12:45 PM, Christian Astúa Rosales wrote: > Everytime I will use my context, will I have to surround my code in > "using(TransactionScope trans = new TransactionScope())"?? Yes. -- Jiri {x2} Cincura (x2develop.com founder) http://blog.cincura.net/ | http://www.ID3renamer.

Re: [Firebird-net-provider] TransactionScope with EntityFramework 4

Well, I added "enlist=true" in conn string. Now I have other problem. Everytime I will use my context, will I have to surround my code in "using(TransactionScope trans = new TransactionScope())"?? Again, thanks for all. -

[Firebird-net-provider] TransactionScope with EntityFramework 4

Hi! I'm trying to use TransactionScope with EF 4 in my project, but the rollback operation doesn't work. Reading in internet I find that I need to add the EnList=true to my connectionString, but when I do it, the Provider displays this error: "There is no active TransactionScope to enlist transact

Re: [Firebird-net-provider] TransactionScope suppress seems not to work

On Wed, Sep 15, 2010 at 11:51, Gareth wrote: > > If I use the option TransactionScope.Suppress in a nested transactionscope at > present the provider seems to ignore this option and will not insert the > first statement - an example. > My understanding is that the first INSERT statement should be

[Firebird-net-provider] TransactionScope suppress seems not to work

If I use the option TransactionScope.Suppress in a nested transactionscope at present the provider seems to ignore this option and will not insert the first statement - an example. var connection1 = new FbConnection(@"initial catalog=DB1.FDB;user id=username;password=pwrd;Enlist=true;"); var conn

Re: [Firebird-net-provider] TransactionScope "Unable to enlist in transaction, a local transaction already exists"

Interestingly, after notice from Vladimir Bodecek [1], this should be working. Are you sure you didn't started some transaction with BeginTransaction and you're using only TS? [1] He also found, that you don't need DTC opening two separate connections. Probably something changed since I last time

Re: [Firebird-net-provider] TransactionScope "Unable to enlist in transaction, a local transaction already exists"

On Sun, Oct 11, 2009 at 14:21, Jiri Cincura wrote: > Probably something changed since I last time looked to > DTC. :o Does anybody knows about some changes in .NET 3.5(SP1) from .NET 2? -- Jiri {x2} Cincura (CTO x2develop.com) http://blog.cincura.net/ | http://www.ID3renamer.com --

Re: [Firebird-net-provider] TransactionScope "Unable to enlist in transaction, a local transaction already exists"

Jiri Thanks for replying it's good to get confirmation from an expert. I think I'm gonna do some kind of workaround in my data access layer so that it keeps the connection alive somehow if it's wrapped inside a TS. Regarding contributing to the DTC code, if it had been 10 years ago then I wouldv

Re: [Firebird-net-provider] TransactionScope "Unable to enlist in transaction, a local transaction already exists"

On Thu, Sep 24, 2009 at 08:50, MartinT wrote: > >From what I can gather Firebird doesn;t support a 2 phase commit so this kind > of scenario with a TransactionScope over 2 separate connections won't work > with FirebirdDotNetProvider because it is promoted to a DTC. Firebird supports 2PC, but TS

Re: [Firebird-net-provider] TransactionScope "Unable to enlist in transaction, a local transaction already exists"

>From what I can gather Firebird doesn;t support a 2 phase commit so this kind of scenario with a TransactionScope over 2 separate connections won't work with FirebirdDotNetProvider because it is promoted to a DTC. woudl be great if somebody more knowledgeable could verify this for me, thanks M

Re: [Firebird-net-provider] TransactionScope "Unable to enlist in transaction, a local transaction already exists"

On Wed, Sep 23, 2009 at 09:21, MartinT wrote: > Hi, sorry for double posting but I am under bit of pressure. Is the > TransactionScope not fully supported by Firebird, or am I doign something > wrong in my method calls to generate this problem, thanks TS is supported, but not the DTC. So you have

Re: [Firebird-net-provider] TransactionScope "Unable to enlist in transaction, a local transaction already exists"

Hi, sorry for double posting but I am under bit of pressure. Is the TransactionScope not fully supported by Firebird, or am I doign something wrong in my method calls to generate this problem, thanks MartinT wrote: > > im trying to utilise the transactionscope in .net with the latest driver > v

Re: [Firebird-net-provider] TransactionScope "Unable to enlist in transaction, a local transaction already exists"

You can use TransactionScope only on one connection. When starting another one, even with same connection string, the internals has no idea that the connection string will be same. And the DTC isn't supported (yet). -- Jiri {x2} Cincura (CTO x2develop.com) http://blog.cincura.net/ | http://www.ID

[Firebird-net-provider] TransactionScope "Unable to enlist in transaction, a local transaction already exists"

im trying to utilise the transactionscope in .net with the latest driver v2.5.1. when i use a TransactionScope object and execute operations within the same FbConnection, it works OK. however when i execute operations on separate FbConnections (with the same connection strings) then i am receiving

Re: [Firebird-net-provider] TransactionScope

On Thu, Dec 4, 2008 at 16:53, Rick Roen <[EMAIL PROTECTED]> wrote: > What does the reg entry look like? I can't find the info. http://support.microsoft.com/kb/306149 -- Jiri {x2} Cincura (CTO x2develop.com) http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com -

Re: [Firebird-net-provider] TransactionScope

What does the reg entry look like? I can't find the info. Rick >It's stored in registry. VS isn't listing GAC. - This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based

Re: [Firebird-net-provider] TransactionScope

On Thu, Dec 4, 2008 at 15:05, Rick Roen <[EMAIL PROTECTED]> wrote: > lost the reference in > VS2008 when I go Project properties - References - Add Reference It's stored in registry. VS isn't listing GAC. -- Jiri {x2} Cincura (CTO x2develop.com) http://blog.vyvojar.cz/jirka/ | http://www.ID3rena

Re: [Firebird-net-provider] TransactionScope

Confirm that v2.1.0 does work for TransactionScope. Thanks. Now after I used the msi installer for v2.1.0 I have lost the reference in VS2008 when I go Project properties - References - Add Reference then .NET tab does not list FirebirdClient, I have to go to the FirebirdClient 2.0 folder and refe

Re: [Firebird-net-provider] TransactionScope

On Thu, Dec 4, 2008 at 13:28, Rick Roen <[EMAIL PROTECTED]> wrote: > FB net provider v2.0.1.0 Did you tried 2.1? -- Jiri {x2} Cincura (CTO x2develop.com) http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com - This SF.N

[Firebird-net-provider] TransactionScope

FB net provider v2.0.1.0 FB server v2.1.1 I believe there is support for TransactionScope, however the following does not work, i.e. at the end of the function both updates were committed and the row values were changed. The second "Using cmd." throws an exception so the tr.Complete is never

Re: [Firebird-net-provider] TransactionScope support

Hello, you have to use one connection. Using more needs, in common, DTC. -- Jiri {x2} Cincura (CTO x2develop.com) http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com - This SF.net email is sponsored by: Microsoft Defy

[Firebird-net-provider] TransactionScope support

Hi all, I'm trying to execute two operations against the same Firebird database, same connection string but different connections. Could you please tell me if I can make the following work with the .NET Provider? I'm using FirebirdClient 2.1.0.0. using (TransactionScope transactionS

Re: [Firebird-net-provider] TransactionScope

Hello: > Hi! > I think we touch upon this before but completely abandon > TransActionScope can some of your guys take a look at this > question > > I've posted on MSDN? > > http://forums.microsoft.com/MSDN/ShowPost.aspx?P

[Firebird-net-provider] TransactionScope

Hi! I think we touch upon this before but completely abandon TransActionScope can some of your guys take a look at this question I've posted on MSDN? http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1608250&SiteID=1 I o

Re: [Firebird-net-provider] TransactionScope support

Carlos Guzmán Álvarez wrote: > If i'm not worng this will not possible to be implemented Firebird > has 2 phase commit support throught the isc_start_multiple API call > ( if i'm worng please let me know ) and i don't think that will > play well with the way TransactionScope works in .NET If I see

Re: [Firebird-net-provider] TransactionScope support

Hello: > C# TransactionScope (LTM ) This is the one that should be working in the provider right now. > C# TransactionScope (DTC) If i'm not worng this will not possible to be implemented Firebird has 2 phase commit support throught the isc_start_multiple API call ( if i'm worng please let me k

Re: [Firebird-net-provider] TransactionScope support

Jon Ege Ronnenberg wrote: > What do you guys think? Could it be implemented? I would like to help > but I don't want to fork the project :-) OK. If I understand this correctly. If I use only one connection (but many queries I want) the LTM is used (it's like "classic" transaction). But if I ope

Re: [Firebird-net-provider] TransactionScope support

Yes, that explains a lot. When IEnlistmentNotification is implemented the provider supports the two-phase commit protocol ie. commit or rollback. What happens in .NET 2.0 is that an Lightweight Transaction Manager (LTM) monitors the transaction and promotes the transaction if the transaction start

Re: [Firebird-net-provider] TransactionScope support

Jon Ege Ronnenberg wrote: > servers. Can anyone please tell me if the firebird provider (v. 2.0.1.0 > ) support IPromotableSinglePhaseNotification or which No. Provider has implementetation for IEnlistmentNotification (but I don't know if this info helps you). -- Jiri {x2} Ci

[Firebird-net-provider] TransactionScope support

Hi all! I'm using TransactionScope and having trouble getting it to work with the firebird provider (v. 2.0.1.0). I saw in one of the forum postings that I have to set Enlist=true in my connection string but no rollback happends when the transaction goes to DTC (Distributed Transaction Coordinato

Re: [Firebird-net-provider] TransactionScope and Interbase

Hello: > Does the provider 2.1.0.0 (beta) support TransactionScope when > connecting to an Interbase database? > > See http://forums.dotnetfirebird.org/Topic.aspx?id=11 That will depend on the version interbase ( it should be a version supporting the same protocol version the provider is using

Re: [Firebird-net-provider] TransactionScope and Interbase

Hello: > AFAIK our provider doesn't care about IB (maybe Carlos, but I'm not > testing it with IB, only pure FB). I do the testing against Firebird only. - Take Surveys. Earn Cash. Influence the Future of IT Join SourceFo

Re: [Firebird-net-provider] TransactionScope and Interbase

Hello: > Does the provider 2.1.0.0 (beta) support TransactionScope when > connecting to an Interbase database? > > See http://forums.dotnetfirebird.org/Topic.aspx?id=11 That will depend on the version interbase ( it should be a version supporting the same protocol version the provider is using

Re: [Firebird-net-provider] TransactionScope and Interbase

Hello: > AFAIK our provider doesn't care about IB (maybe Carlos, but I'm not > testing it with IB, only pure FB). I do the testing against Firebird only. - Take Surveys. Earn Cash. Influence the Future of IT Join SourceF

Re: [Firebird-net-provider] TransactionScope and Interbase

Daniel Letecky wrote: > Carlos/Jiri, > > Does the provider 2.1.0.0 (beta) support TransactionScope when > connecting to an Interbase database? AFAIK our provider doesn't care about IB (maybe Carlos, but I'm not testing it with IB, only pure FB). Some old versions are "supported" but only thank

[Firebird-net-provider] TransactionScope and Interbase

Carlos/Jiri, Does the provider 2.1.0.0 (beta) support TransactionScope when connecting to an Interbase database? See http://forums.dotnetfirebird.org/Topic.aspx?id=11 Thanks, Dan Letecky http://www.dotnetfirebird.org - T

[Firebird-net-provider] TransactionScope support

Hello: I'm thinking on see how to implement the TrasnactionSCope support in the v2.0 of the provider. Does anybody knows of good article on this subject ?? -- Carlos Guzmán Álvarez Vigo-Spain - Take Surveys. Earn Cash