Re: [Firebird-net-provider] How can I execute several commands in a single FbCommand object

[Carlos G. A. <car...@te...>]

Hello:


> I can confirm that following code does not work:

Try this:

FbTransaction transaction = connection.BeginTransaction();

string sql = "CREATE TABLE A(F1 INTEGER NOT NULL, F2 INTEGER NOT NULL);" 
+ "ALTER TABLE A ADD CONSTRAINT PK_A PRIMARY KEY (F1, F2);";
			
FbCommand command = new FbCommand(sql, connection, transaction);

FbDataReader reader = command.ExecuteReader();
while (reader.NextResult())
{
}

reader.Close();
transaction.Commit();






-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain


"Todos somos muy ignorantes. Lo que ocurre es que no todos ignoramos las 
mismas cosas."

Albert Einstein.