Checking what the best way is to execute a DA command using LocalCommand

Remoting SDK
1

I just wrote some code to execute a command from a da schema from the server (in a service)

I was surprised a bit I had to use

IDbCommand.CreateParameter

followed by a cmd.Parameters.Add(object)

Is this the advised approach?

Everything works but I just wanted to check since the redundant call surprises me a bit

image
image958×345 25.8 KB

3

Hi,

The one thing I would change is

"return (iret > 0)".

ExecuteNonQuery() returns -1 when
the procedure runs with SET NOCOUNT ON, so a successful write is reported as a failure.

Use

"return (iret >= 0);"