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

[mailmur <ma...@ya...>]

>> Firebird cannot run simple compound queries such
>> as "INSERT... ; UPDATE...;" in one go through
>> executequery.

> But it can't be executed using executenonquery
> because Firebid server 
> doesn't support batch command execution ;)

Yes, I know. Thats why I expressed my feelings on this
case ;-)

It will often complicates the clientside programs to
overcome this lack of FB feature. If I am right, a
sort of workaround is to create stored procedures for
such operations.

But if batch queries are dynamically generated on fly
and varies heavily based on business logic, then
storedprocs are not a solution. Implementing dynamic
queries at serverside are very very tricky. 

__________________________________
Do you Yahoo!?
The New Yahoo! Shopping - with improved product search
http://shopping.yahoo.com