topic Re: SDE database connection is populated with different feature class names in SDK in ArcGIS Pro SDK Questions

SDE database connection is populated with different feature class names in SDK

SumitMishra_016 — Tue, 27 Feb 2024 10:14:51 GMT

I am Obtaining Featureclass names From SDE Geodatabase using following code:

public async Task ObtainingDefinitionsFromGeodatabase()
{
  await ArcGIS.Desktop.Framework.Threading.Tasks.QueuedTask.Run(() =>
  {
    using (Geodatabase geodatabase = new Geodatabase(new DatabaseConnectionFile(new Uri("path\\to\\sde\\file\\sdefile.sde"))))
    {
      IReadOnlyList<FeatureClassDefinition> enterpriseDefinitions = geodatabase.GetDefinitions<FeatureClassDefinition>();
      List<string> featureclassList = enterpriseDefinitions.Select(x => x.GetName()).ToList();
      
    }
  });
}

But featureclassList is populated with different feature class names along with actual feature class names contained in the database. In Catalog, it is showing correct feature classes.

I am using ArcGIS pro SDK 3.1 and Oracle SDE connection. What's wrong in the above code @Wolf, @GKmieliauskas , @UmaHarano ?

Re: SDE database connection is populated with different feature class names in SDK

Aashis — Tue, 27 Feb 2024 16:40:21 GMT

@SumitMishra_016 I am curious to know what your expectations were and what you are seeing. Could you please elaborate?

Re: SDE database connection is populated with different feature class names in SDK

SumitMishra_016 — Wed, 28 Feb 2024 06:48:38 GMT

Thanks for the reply @Aashis,

When opening the sde connection in catalog, it shows correct Enterprise Geodatabase Feature Classes which are associated with the username provide in the sde connection.

But when I am using

geodatabase.GetDefinitions<FeatureClassDefinition>()

it shows other Enterprise Geodatabase Feature Classes which are not associated with the username provide in the sde connection

Re: SDE database connection is populated with different feature class names in SDK

Aashis — Thu, 29 Feb 2024 15:30:19 GMT

@SumitMishra_016 , it seems like the catalog's view-only behavior for the owner, and the API shows everything the user has access to.

Re: SDE database connection is populated with different feature class names in SDK

SumitMishra_016 — Fri, 01 Mar 2024 04:28:37 GMT

Hi @Aashis,

List only object owned by connecting user was not checked but it was still showing correct feature classes.

Can I use this(List only object owned by connecting user) in code?

Re: SDE database connection is populated with different feature class names in SDK

Aashis — Fri, 08 Mar 2024 18:48:58 GMT

Refer to- https://community.esri.com/t5/arcgis-pro-sdk-questions/obtaining-featureclass-names-from-sde-file-path/m-p/1393344/highlight/true#M11215