[Firebird-net-provider] Problem with FbCommandBuilder.DeriveParameters()

[olegmad <ol...@ya...>]

Hello Carlos!

I am have probler with FbCommandBuilder.DeriveParameters() too.

I create this procedure:
--------------------------------------------
CREATE PROCEDURE MYPROC
RETURNS (
    "id" INTEGER)
AS
begin
    "id" = 777;
end
--------------------------------------------

And this code:
--------------------------------------------
using System;
using System.Data;

using System.Data.Common;

using FirebirdSql.Data.Firebird;

namespace ConsoleApplication

{

class MainClass

{

static private readonly string ConnectionString =
@"Server=80.80.104.12;Database=c:\temp\carlos.gdb;Charset=UNICODE_FSS;Connec
tion Lifetime=15;Dialect=3;User=carlos;Password=carlos;";

static void Main(string[] args)

{

FbConnection connection = new FbConnection(ConnectionString);

connection.Open();

FbTransaction transaction = connection.BeginTransaction();

FbCommand command = new FbCommand("MYPROC", connection, transaction);

command.CommandType = CommandType.StoredProcedure;

FbCommandBuilder.DeriveParameters(command);

transaction.Commit();

connection.Close();

}

}

}

--------------------------------------------

I catch exception:

Unhandled Exception: FirebirdSql.Data.Firebird.FbException: Execute requires
the Command object to have a Transaction object when the Connection object
assigned to the command is in a pending local transaction.  The Transaction
property of the Command has not been initialized.
   at
FirebirdSql.Data.Firebird.DbSchema.FbAbstractDbSchema.GetDbSchemaTable(FbCon
nection connection, Object[] restrictions)
   at FirebirdSql.Data.Firebird.FbConnection.GetDbSchemaTable(FbDbSchemaType
schema, Object[] restrictions)
   at FirebirdSql.Data.Firebird.FbCommandBuilder.DeriveParameters(FbCommand
command)
   at ConsoleApplication.MainClass.Main(String[] args) in
c:\vss\consoleapplication3\class1.cs:line 21


Thanks.