topic get_datasets doesn't return all the datasets in the database in ArcObjects SDK Questions

get_datasets doesn't return all the datasets in the database

ShawnHolyoak — Tue, 24 Jul 2012 20:55:42 GMT

I have code that gets all the Feature Datasets in a database in order to loop through them and find the one I want. This code works fine in an SDE 9.2 database, but not in a version 10 SP 2 database. I have 24 feature datasets in the database, and the user has at least select permissions on all of them, but the code only returns 3 feature datasets. The code is very simple, shown below. What the heck is going on?

   ESRI.ArcGIS.Geodatabase.IWorkspace _ws = (ESRI.ArcGIS.Geodatabase.IWorkspace)aWorkspaceEdit;    ESRI.ArcGIS.Geodatabase.IEnumDataset _ed = _ws.get_Datasets(ESRI.ArcGIS.Geodatabase.esriDatasetType.esriDTFeatureDataset);    ESRI.ArcGIS.Geodatabase.IDataset _ds = null;    while ((_ds = _ed.Next()) != null) {     if (_ds.BrowseName == _datasetName) {      ESRI.ArcGIS.Geodatabase.IEnumDataset _dsed = _ds.Subsets;      ESRI.ArcGIS.Geodatabase.IDataset _dsfc = null;      while ((_dsfc = _dsed.Next()) != null) {       if (_dsfc.BrowseName == aFeatureClassName) {        _fc = (ESRI.ArcGIS.Geodatabase.IFeatureClass)_dsfc;        break;       }      }     }     if (_fc == null) {      _ds = _ed.Next();     } else {      break;     }    }    _ed.Reset();

Re: get_datasets doesn't return all the datasets in the database

sapnas — Tue, 31 Jul 2012 13:01:04 GMT

Are you able to view those feature datasets from arccatalog with the workspace connection utilized in your code?

Re: get_datasets doesn't return all the datasets in the database

ShawnHolyoak — Tue, 31 Jul 2012 13:05:37 GMT

Are you able to view those feature datasets from arccatalog with the workspace connection utilized in your code?

Yes. Plus a few extraneous characters to meet the minimum reply length, ESRI.

Re: get_datasets doesn't return all the datasets in the database

sapnas — Tue, 31 Jul 2012 13:28:44 GMT

The feature dataset retrieved by if (_fc == null) {
_ds = _ed.Next();
} logic is overwritten by next feature datasetwhile ((_ds = _ed.Next()) != null). Did you intend to skip the feature dataset in your logic? if not

Replace

if (_fc == null) {
_ds = _ed.Next();
}
else {
break;
}

with

if(_fc!=null)
{
break;
}

Re: get_datasets doesn't return all the datasets in the database

ShawnHolyoak — Tue, 31 Jul 2012 14:01:45 GMT

The feature dataset retrieved by if (_fc == null) {
_ds = _ed.Next();
} logic is overwritten by next feature datasetwhile ((_ds = _ed.Next()) != null). Did you intend to skip the feature dataset in your logic? if not

Replace

if (_fc == null) {
_ds = _ed.Next();
}
else {
break;
}

with

if(_fc!=null)
{
break;
}

Not sure why any of that code is in there to be honest. I made your recommended changes, as you're correct, it was skipping some feature datasets. Unfortunately, I'm still short one dataset that the user has full select, insert, update, and delete privileges on.

Re: get_datasets doesn't return all the datasets in the database

sapnas — Sun, 12 Dec 2021 00:48:53 GMT

I was able to get all the feature datasets with the same logic. BTW never use IEnumDataset if you intend to just iterate through the objects to retrieve the objectname. It not only slows down the proces it also causes memory leak. Use IEnumDatasetName instead. You can use below logic to construct featureclass from IDatasetName.

 IName name = datasetName as IName;
IDataset _dsfc = name.Open() as IDataset;
_fc = (ESRI.ArcGIS.Geodatabase.IFeatureClass)_dsfc;

Re: get_datasets doesn't return all the datasets in the database

ShawnHolyoak — Sun, 12 Dec 2021 00:48:55 GMT

I was able to get all the feature datasets with the same logic. BTW never use IEnumDataset if you intend to just iterate through the objects to retrieve the objectname. It not only slows down the proces it also causes memory leak. Use IEnumDatasetName instead. You can use below logic to construct featureclass from IDatasetName.
 IName name = datasetName as IName;
IDataset _dsfc = name.Open() as IDataset;
_fc = (ESRI.ArcGIS.Geodatabase.IFeatureClass)_dsfc;

Thanks for the suggestions. I'm unclear, though, about your suggested approach. I don't want to get the object name. I need to get a reference to a specific feature class to then edit it. I see that your code gives me a feature class at the end; what object type is "datasetName" in your code?

Re: get_datasets doesn't return all the datasets in the database

sapnas — Tue, 31 Jul 2012 14:48:29 GMT

Yes. You want a reference of one feature class not all feature classes in the feature dataset. If a feature dataset contains 20 feature class your logic is creating 20 feature class objects in memory although you are not using it. IDatasetName object supply object name info and not the object itself. When you debug your logic you may notice a delay on _ds.Subsets and _ws.get_Datasets statements. I modified your code to use IDatasetName. If you prefer less code then use IWorkspace2.get_NameExists method instead of iterating through the datasetnames.

ESRI.ArcGIS.Geodatabase.IEnumDatasetName _ed = _ws.get_DatasetNames(ESRI.ArcGIS.Geodatabase.esriDatasetType.esriDTFeatureDataset);             ESRI.ArcGIS.Geodatabase.IDatasetName _ds = null;             IFeatureClass _fc = null;                          while ((_ds = _ed.Next()) != null)             {                 if (_ds.Name==_datasetName)                 {                     ESRI.ArcGIS.Geodatabase.IEnumDatasetName _dsed = _ds.SubsetNames;                     ESRI.ArcGIS.Geodatabase.IDatasetName _dsfc = null;                     while ((_dsfc = _dsed.Next()) != null)                     {                         if (_dsfc.Name==aFeatureClassName)                        {                             IName name = _dsfc as IName;                             IDataset dataset = name.Open() as IDataset;                             _fc = (ESRI.ArcGIS.Geodatabase.IFeatureClass)dataset;                             break;                         }                     }                 }                 if (_fc != null)                 {                                          break;                 }             }             _ed.Reset();

Re: get_datasets doesn't return all the datasets in the database

ShawnHolyoak — Sun, 12 Dec 2021 00:48:58 GMT

ESRI.ArcGIS.Geodatabase.IEnumDatasetName _ed = _ws.get_DatasetNames(ESRI.ArcGIS.Geodatabase.esriDatasetType.esriDTFeatureDataset);
            ESRI.ArcGIS.Geodatabase.IDatasetName _ds = null;
            IFeatureClass _fc = null;
            
            while ((_ds = _ed.Next()) != null)
            {
                if (_ds.Name==_datasetName)
                {
                    ESRI.ArcGIS.Geodatabase.IEnumDatasetName _dsed = _ds.SubsetNames;
                    ESRI.ArcGIS.Geodatabase.IDatasetName _dsfc = null;
                    while ((_dsfc = _dsed.Next()) != null)
                    {
                        if (_dsfc.Name==aFeatureClassName)                        {
                            IName name = _dsfc as IName;
                            IDataset dataset = name.Open() as IDataset;
                            _fc = (ESRI.ArcGIS.Geodatabase.IFeatureClass)dataset;
                            break;
                        }
                    }
                }
                if (_fc != null)
                {
                    
                    break;
                }
            }
            _ed.Reset();

That not only helps improve my code overall, it works and gives me all of my feature datasets. I've accepted your answer. Thanks for all of your help in resolving this!

Re: get_datasets doesn't return all the datasets in the database

sapnas — Wed, 01 Aug 2012 13:32:01 GMT

Glad I could help!