Re: [Firebird-net-provider] Feature Request: Multiple Transactions per Connection....

[Willibald K. <wi...@dw...>]

Hello!

> I don't quite see the problem since one can associate a different
> transaction to every FbCommand-object
> e.g:
>  FbConnection conn = new FbConnection(...)
>  FbTransaction txn = conn.BeginTransaction();

Well, following is not possible (but should be - IMHO):
  FbTransaction txn1 = conn.BeginTransaction();
  FbTransaction txn2 = conn.BeginTransaction(); // throws exception.

So you would have to do

  FbConnection con1 = new FbConnection(..)
  FbConnection con2 = new FbConnection(..)
  FbConnection con3 = new FbConnection(..)
  FbTransaction txn1 = con1.BeginTransaction();
  FbTransaction txn2 = con2.BeginTransaction();
  FbTransaction txn3 = con3.BeginTransaction();
Just to get three independant transactions! (e.g one for generating a
report, the other for fetching some data and the third e.g. for  modifying
some data)

See what I mean? Now if you've got five clients with all doing the same, you
end up with 5*3 connections....

Willi