[Firebird-net-provider] TransactionScope support

[Aitor Gómez González]

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 transactionScope = new
TransactionScope())
            {
                using (FbConnection connection = new
FbConnection(myConnectionString))
                {
                    connection.Open();

                    using (FbCommand command = connection.CreateCommand())
                    {
                        command.CommandText = ...
                        command.ExecuteNonQuery();
                    }
                }

                using (FbConnection connection = new
FbConnection(myConnectionString))
                {
                    connection.Open();

                    using (FbCommand command = connection.CreateCommand())
                    {
                        command.CommandText = ...
                        command.ExecuteNonQuery();
                    }
                }

                transactionScope.Complete();
            }



Thanks in advance,
Aitor.

-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider