Re: [Firebird-net-provider] Working with transactions

2012-04-11 Thread Gerdus van Zyl
The way I solve it in my code is to create a class that manages database connection,transactions and commands: eg. DatabaseContext pseudo code: context.begin_transaction() // opens connection, starts transaction context.runsql(sql) // creates command using current connection and transaction contex

Re: [Firebird-net-provider] Working with transactions

2012-04-11 Thread Jiri Cincura
On Wed, Apr 11, 2012 at 9:59 AM, Russell Rose wrote: > The 2nd routine is sometimes called when there is a pending transaction and > sometimes not. Your code should know... -- Jiri {x2} Cincura (x2develop.com founder) http://blog.cincura.net/ | http://www.ID3renamer.com ---

[Firebird-net-provider] Working with transactions

2012-04-11 Thread Russell Rose
I was wondering if there was any way to determine if there is a pending transaction outstanding. I have a single connection to a database and have something like the following code: FbConnection conn; FBCommand cmd = conn.CreateCommand();; cmd.Transaction = conn.BeginTransaction(); I then call