[Firebird-net-provider] Batch / DDL execution

[Todd <pal...@ya...>]

Anyone succesfully using the .Net provider to do batch / DDL execution?
I'd appreciate any tips / sample code.

I tried the FbScript / FbBatchExecution route, which is workable after
I fixed about 5 bugs in the parsing.  I'd rather not have to parse the
SQL client side (that's what the server does).

I tried multiple SQL statements in a FbCommand using ExecuteReader()
and reader.NextResult(), which fails for stored procedures and triggers
with "Error 104 unexpected end of command" w/o using the SET TERM
syntax and fails with "unknown token" using the SET TERM syntax.

FbCommand.ExecuteNonQuery() works for a single stored proc or trigger,
but not a script.

Thoughts?

Todd