How to get object id for the Query Layer

Question

Hello everyone, I am need of your assistance.

I am unable to get object id for the Query Layer. I can get it for shapefile or sde feature class. 
Please take a look at the sample code below.

Thank you,
Trushar Mistry

//--------------------------------------------------
        // trusharm 2024-01-04 4:37pm, query layer GetDefinition() throws
        // exception so we are unable to get field names, hence we cannot
        // query layer at the moment until Esri fixes the issue
        [NotNull]
        private static string GetIdFieldForSpatialView([NotNull] FeatureLayer selectedFeatureLayer) =>
            ((CIMSqlQueryDataConnection)selectedFeatureLayer.GetDataConnection())
            .OIDFields
            .Contains("OBJECTID", StringComparison.InvariantCulture)
                ? "OBJECTID"
                : throw new InvalidOperationException("The view must at least have OBJECTID as unique index");

trushar · Answer

Thank you for the link, I noticed DaveFullerton is running into same issue.
I am using ArcGIS Pro 3.2.1 and I am connected to SqlServer 2016.

Do I open a bug ticket with Esri?

Thanks,
Trushar

GKmieliauskas · Answer

Could you please specify more information about ArcGIS Pro version and database type? There are some issues with GetDefinition method in ArcGIS Pro 3.2 and PostgreSql database. More info here.

trushar · Answer

Thank you for your example @GKmieliauskas!

Apologies, I posted the question in rush and did not explain correctly nor did I copy the correct code sample.

Here is the core issue that I was attempting to get help on. I need access to column names and data under it so I can further bind it to my UI:

using var table = (selectedFeatureLayer.GetDataConnection() is CIMSqlQueryDataConnection { WorkspaceFactory: WorkspaceFactory.SDE })
                    ? selectedFeatureLayer.GetTable()
                    : throw new InvalidOperationException("...");

var field in table.GetDefinition().GetFields()

The `GetDefinition()` fails for me for layer type `CIMSqlQueryDataConnection`. The exception is coming from `ArcGIS.Core.Data.GetDefinitionHandle()`. Is it possible there is an alternate way to get field names for query layers, would you happen to know?

Thank you again for your time,
Trushar M