[Firebird-net-provider] Error in 1.6 Beta 1

[work <she...@fo...>]

Hello!

When I set on pooling, I can't close connection.

For example (it's real code):

private string sСonnectionString =
"User=sysdba;"+
"Password=masterkey;" +
"Database=testbase;"    +
"DataSource=localhost;" +
"Port=3050;" +
"Dialect=3;" +
"Charset=WIN1251;" +
"Connection lifetime=15;" +
"Pooling=true;" +                               // !!!!!!!!!!!!!!!!!
"Packet Size=8192";

public short MayWork(string sUniqKey)
{
       short stResult=0;
       FbConnection Connect=new FbConnection(sСonnectionString);
       try
       {
           Connect.Open();
           try
           {
               FbTransaction Transact=Connect.BeginTransaction(FbTransactionOptions.Read|FbTransactionOptions.NoWait|FbTransactionOptions.ReadCommitted|FbTransactionOptions.RecVersion);
               try
               {
                   FbCommand Command=new FbCommand();
                   Command.Connection=Connect;
                   Command.Transaction=Transact;

                   Command.CommandType=CommandType.StoredProcedure;
                   Command.CommandText="MayWorkForos4User";
                   Command.Parameters.Add("@CUNIQKEY",FbDbType.Char,32).Value=sUniqKey;
                   Command.Parameters.Add("@IRESULT",FbDbType.SmallInt);
                   Command.Parameters[1].Direction=ParameterDirection.ReturnValue;
                   Command.ExecuteNonQuery();

                   stResult=Convert.ToInt16(Command.Parameters[1].Value);
                   Transact.Commit();
                   Command.Dispose();
               }
               catch(Exception ex)
               {
                   stResult=2;
                   Transact.Rollback();
               }
           }
           finally
           {
              Connect.Close();        // ERROR!!!!!!!!!!!!!!!!!!!!!!!!
              Connect.Dispose();
           }
       }
       catch(Exception e)
       {
            stResult=2;
       }
      return stResult;
}

The error message is: "Object reference not set to an instance of an
object".

Best regards, Alex Shevelev                         mailto:she...@fo...