topic Re: Open SDE Geodatabase with WorkspaceConnectionString in ArcGIS Pro SDK Questions

Open SDE Geodatabase with WorkspaceConnectionString

Zoggo — Tue, 27 Jul 2021 11:33:37 GMT

I have a WorkspaceConnectionString from CIMFeatureDatasetDataConnection looking like that:

With this ConnectionString I like to open a Enterprise Geodatabase (SDE):

GDB = new Geodatabase(new DatabaseConnectionProperties(EnterpriseDatabaseType.SQLServer)

What is the best way to do this?

Re: Open SDE Geodatabase with WorkspaceConnectionString

Aashis — Wed, 28 Jul 2021 02:52:46 GMT

@Zoggo, The Pro SDK doesn’t have a method to open/connect the geodatabase from a workspace connection string. I am curious to know why you use CIMFeatureDatasetDataConnection. Can you use FeatureLayer.GetFeatureClass().GetDatastore() as Geodatabase instead?

Re: Open SDE Geodatabase with WorkspaceConnectionString

Zoggo — Wed, 28 Jul 2021 05:40:41 GMT

I'm working with a linear referencing layer (Route Feature Layer). The event table is in a filegeodatabase and the route features is in a enterprise geodatabase. If I use FeatureLayer.GetFeatureClass().GetDatastore() as Geodatabase I only get the filegeodatabase workspace from the table but I need the enterprise geodatabase workspace from the route features.

Re: Open SDE Geodatabase with WorkspaceConnectionString

Aashis — Tue, 03 Aug 2021 18:11:05 GMT

@Zoggo , A workaround to access the route feature class’s geodatabase from route event layer

// Get all layers from the map IReadOnlyList<Layer> layers = MapView.Active.Map.GetLayersAsFlattenedList(); // Assuming route event layer is the first layer of map CIMRouteEventDataConnection connection = layers[0].GetDataConnection() as CIMRouteEventDataConnection; // Get connection to the route feature class CIMDataConnection routeFeatureClassConnection = connection.RouteFeatureClass ; // Create a feature layer using the route feature class connection FeatureLayer featureLayer = LayerFactory.Instance.CreateLayer(routeFeatureClassConnection, MapView.Active.Map, layerName: "RouteFeatureClass" ) as FeatureLayer; // Use feature layer to access the geodatabase Geodatabase geodatabase = featureLayer.GetFeatureClass().GetDatastore() as Geodatabase;

Re: Open SDE Geodatabase with WorkspaceConnectionString

Zoggo — Tue, 23 Nov 2021 10:26:26 GMT

Basically it works. But the solution isn't nice. Because it adds the FeatureClass to the map. That's not wanted and very slow. Is there no other way without adding the layer to the map?