Obtaining Featureclass names From SDE file path for adding to map in .net SDK

[sumalain1]

hi  @GKmieliauskas @Wolf

how can I filter the following featureNameslist in the geodatabase created using Oracle SDE which don't have access to user:

Geodatabase geodatabase = new Geodatabase(new DatabaseConnectionFile(new Uri("path to sde")));

var featureNameslist = geodatabase.GetDefinitions<FeatureClassDefinition>().Select(def => def.GetName()).ToArray();

Just like in the catalog

[Aashis]

The following should work. Could you pls try?

The SQLSyntax parses the fully qualified dataset name to the db, owner, and dataset names.

IReadOnlyList<FeatureClassDefinition> featureClassDefinitions = geodatabase.GetDefinitions<FeatureClassDefinition>();
List<FeatureClassDefinition> filteredDefinitions = featureClassDefinitions.Where(def =>
{
SQLSyntax sqlSyntax = geodatabase.GetSQLSyntax();
(string dbName, string ownerName, string tableName) = sqlSyntax.ParseTableName(def.GetName());

return ownerName == "your_owner_name";
}).ToList();

[sumalain1 · Accepted solution]

Thanks @Aashis for the reply,

The purpose to list feature classes from SDE is to add selected feature class to map. There are multiple owners in the sde, how will I know that which owner has access to the connected user of the SDE? Just like Catalog shows the accessible list of enterprise feature classes.

IReadOnlyList<FeatureClassDefinition> featureClassDefinitions = geodatabase.GetDefinitions<FeatureClassDefinition>();
List<string> allOwnerNames = featureClassDefinitions.Select(def =>
{
    SQLSyntax sqlSyntax = geodatabase.GetSQLSyntax();
    (string dbName, string ownerName, string tableName) = sqlSyntax.ParseTableName(def.GetName());

    return ownerName;
}).ToList();

List<string> distinctOwnerNames = allOwnerNames.Distinct().ToList();

[sumalain1]

Hi @Aashis,

 how will I know that which owner has access to the connected user of the SDE?

[Aashis]

I am presuming that you are trying to find the connected user.

DatabaseConnectionProperties connectionProperties= geodatabase.GetConnector() as DatabaseConnectionProperties;
string user = connectionProperties.User;

DatabaseConnectionProperties  

[sumalain1]

Hi @Aashis,

Thanks for the reply. But the user and owner are not same.  Any user can have access to multiple owners.

In Catalog, it is filtered correctly, do you know any way to filter that?

[Aashis]

In ArcGIS, user accounts determine who owns what data. User accounts also provide a way to control what type of access a person or client application has to a database or geodatabase and its datasets. ArcGIS generally recommends that the owner and schema have matching names.

The Catalog UI does the following - 

// Get the currently logged user
DatabaseConnectionProperties connectionProperties= geodatabase.GetConnector() as DatabaseConnectionProperties;
string user = connectionProperties.User;

// Filter feature classes based on the user
IReadOnlyList<FeatureClassDefinition> featureClassDefinitions = geodatabase.GetDefinitions<FeatureClassDefinition>();
List<FeatureClassDefinition> filteredDefinitions = featureClassDefinitions.Where(def =>
{
	SQLSyntax sqlSyntax = geodatabase.GetSQLSyntax();
	(string dbName, string ownerName, string tableName) = sqlSyntax.ParseTableName(def.GetName());

	return ownerName == user;
}).ToList();

If you find something else, please log a bug from tech support for further investigation. 

[sumalain1]

Hi @Aashis,

Thanks for the reply, 

User accounts may have access to different owner's table which may not be owned by the user. In that case how to filter out only those tables from the below featureClassDefinitions:

IReadOnlyList<FeatureClassDefinition> featureClassDefinitions = geodatabase.GetDefinitions<FeatureClassDefinition>();

The Catalog UI displays only accessible feature classes with or without List only object owned by connecting user checkbox.