[Firebird-net-provider] (FbCommandBuilder) Object reference not set to ...

[Ivan - <pre...@bk...>]

Is this behavior by-design or a bug ?

FbConnection con = new FbConnection(cs);
con.Open();
FbTransaction tran = con.BeginTransaction();
FbDataAdapter ad = new FbDataAdapter(@"SELECT * FROM TBL", con);
DataSet ds = new DataSet();
ad.Fill(ds, "TBL");
con.Close();
tran = con.BeginTransaction();
ad.SelectCommand.Transaction = tran;
FbCommandBuilder b = new FbCommandBuilder(ad);
b.QuotePrefix = String.Empty;
b.QuoteSuffix = String.Empty;

ad.Update(ds, "TBL1001625"); // <--- Exception goes here
/*
"Object reference not set to an instance of an object"
source: FbCommand.cs - Prepare()
statement = new FbStatement(Connection, 
              Transaction, 
              Parameters,
              commands[actualCommand], //commands is null, actualCommand == -1

              CommandType);	

*/
actually, it's not a bug in FbCommandBuilder, because we can change last line to
DataSet ds1 = new DataSet();
ad.Fill(ds1, "TBL");
and there will be an exception too.

I'm using Release of FB.NET 1.0 provider. Database - firebird 1.5 (RC3), Dialect 1.