Obtain the identitity value from an insert

FabianoFerrazza1 — Mon, 30 Nov 2015 11:03:30 GMT

Hi all,

i need insert a row in a not SDE table and retrieve the identity id.

In sql is quite simple:

INSERT INTO TAB1 (val1,val2,val3) OUTPUT INSERTED.IDVALUES (0,1,2).

I can't use a direct SQL connection, i must use arcobjects.

The ISqlWorkspace.ExecuteSQL is ususable, because is void.

The dbms is SQLServer 2008 R2

Could you help me?

Thanks

Fabiano

topic Obtain the identitity value from an insert in ArcObjects SDK Questions