topic Re: Get standalone non-spatial table in SOE in ArcObjects SDK Questions

Get standalone non-spatial table in SOE

SanajyJadhav — Wed, 05 Sep 2012 14:01:03 GMT

Hello,

I am developing REST SOE.It queries the standalone non spatial table in the map service.

I am not being able to figure out how to get reference to this ITable.I can access other feature classes but am facing problem to access this ITable.

Can anybody help me on this issue? I would appreciate it.

Thanks.

Re: Get standalone non-spatial table in SOE

SanajyJadhav — Sat, 11 Dec 2021 17:56:45 GMT

I figured it out. I pasting my code if anybody is interested.

        private ITable SetNonSpatialTable(string tableName)
        {
            try
            {
                //get map server
                IMapServer3 mapServer = (IMapServer3)serverObjectHelper.ServerObject;

                //get default map name
                string mapName = mapServer.DefaultMapName;

                //get map server info
                IMapServerInfo3 pMapSrverInfo = mapServer.GetServerInfo(mapName) as IMapServerInfo3;

                //get standalone table info collection
                IStandaloneTableInfos pStandaloneTblInfos = pMapSrverInfo.StandaloneTableInfos;

                int? tableID = null;
                //get the ID of the desired table
                for (int i = 0; i < pStandaloneTblInfos.Count; i++)
                {
                    IStandaloneTableInfo pStandaloneTblInfo = pStandaloneTblInfos.get_Element(i);

                    //if the name matches, then set table ID
                    if (pStandaloneTblInfo.Name.ToUpper() == tableName.ToUpper())
                    {
                        tableID = pStandaloneTblInfo.ID;
                    }
                }

                //get map server object
                IMapServerObjects3 pMapServerObj = serverObjectHelper.ServerObject as IMapServerObjects3;

                if (tableID != null)
                {
                    ITable pTable = pMapServerObj.get_StandaloneTable(mapName, Convert.ToInt16(tableID));
                    return pTable;
                }

                return null;
            }
            catch (Exception ex)
            {
                string errMsg = "An Error occured in the SOE method - SetNonSpatialTable - " + " " + "Error : " + ex.Message
               + "Stack Trace : " + " " + ex.StackTrace;
                logger.LogMessage(ServerLogger.msgType.error, "SetNonSpatialTable", 400, errMsg);
                return null;
            }
        }

Re: Get standalone non-spatial table in SOE

CarolineShepherd — Sat, 24 Nov 2012 19:16:47 GMT

I was just wondering how I was going to achieve the same thing!

Thanks for posting the solution!

Caroline

Re: Get standalone non-spatial table in SOE

SanajyJadhav — Sun, 25 Nov 2012 05:13:23 GMT

You are welcome.

Re: Get standalone non-spatial table in SOE

PaulSchneider — Sat, 11 Dec 2021 17:56:48 GMT

Used this today...

Utilized the .GetDataSource method of the IMapServerDataAccess

...
[LEFT]IMapServer3 mapServer = serverObjectHelper.ServerObject as IMapServer3;
IStandaloneTableInfos satInfos = _MapServerInfo.StandaloneTableInfos;
IStandaloneTableInfo satInfo;
string myTableName;

for (int i = 0; i < satInfos.Count; i++)
{[INDENT]satInfo = satInfos.get_Element(i);
if (myTableName.Equals(satInfo.Name, StringComparison.InvariantCultureIgnoreCase) == true)
{
[INDENT]ITable myTable = setNonSpatialTable(mapServer.DefaultMapName, i);
break;[/INDENT]}[/INDENT]}
...

private ITable setNonSpatialTable(string mapName, int tablei) 
{
[INDENT]if (tablei != null)
{
[INDENT]tablei = tablei + _MapServerInfo.MapLayerInfos.Count; //Tables listed after layers

ITable outTable = (ITable)_MapServerDataAccess.GetDataSource(mapName, tablei);
return outTable;[/INDENT]}
return null;[/INDENT]}
...[/LEFT]

Thanks!