topic SQL Sequence in ArcObjects SDK Questions

SQL Sequence

GregRieck — Mon, 04 Nov 2013 21:29:56 GMT

Hello,

I have created a stored procedure and a sequence in SQL Express 2012 to return an INTEGER of the "Next ID". Is there a way to call the stored procedure using ArcObjects such that it returns the INT value?

Greg

Re: SQL Sequence

ParitoshGupta — Mon, 04 Nov 2013 21:49:06 GMT

Hi Greg
I am not sure whether this will help or not but as far as I can understand, you need to fire a sql query to get results using ArcObjects. The suitable interface to do this is ISQLWorkspace.

/* A SQL workspace is a relational database that may or may not be a geodatabase. After creating a workspace with the SqlWorkspaceFactory class (and the IWorkspaceFactory interface), this interface is used to retrieve data in a read-only manner as query classes and query cursors */

http://resources.arcgis.com/en/help/arcobjects-net/componenthelp/index.html#/OpenQueryCursor_Method/002500000861000000/

Re: SQL Sequence

GregRieck — Sun, 12 Dec 2021 05:14:13 GMT

Paritosh,

Yes, thank you, that does work. I was surprised to see that just passing in the name of the stored procedure was all that was required.

          ISqlWorkspace sqlws = AnIWorkspace as ISqlWorkspace;
          ICursor cur = sqlws.OpenQueryCursor("YourStoredProcedureName");
          if (cur != null)
          {
            IRow row = cur.NextRow();
            if (row != null)
              return (int)row.get_Value(0);
          }