The DeriveParameters Function has a note bug: it does not check
to see if the command is enlisted in a transaction before requesting the
parameters from the server, so if I try to use it during a transaction...
Error:
Execute requires the command to have a transaction object when the connection assigned to the command is in a pending local transaction. The Transaction property of the command has not been initialized.
Is there a way to use sqlTransacton object with the sqlCommandBuiler object?
Thanks
to see if the command is enlisted in a transaction before requesting the
parameters from the server, so if I try to use it during a transaction...
Error:
Execute requires the command to have a transaction object when the connection assigned to the command is in a pending local transaction. The Transaction property of the command has not been initialized.
Is there a way to use sqlTransacton object with the sqlCommandBuiler object?
Thanks