Detecting the presence of an attribute index on a runtime geodatabase class

EdwardBlair — Tue, 21 Feb 2017 13:38:51 GMT

Am working with a (SQLite) runtime Geodatabase with an app that relies on the presence of several attribute indexes to provide good performance. Is there a way in the ArcGIS runtime .net SDK to detect the presence of an index so I can take some action if its not there?

Thanks,

Re: Detecting the presence of an attribute index on a runtime geodatabase class

EdwardBlair — Wed, 22 Feb 2017 15:39:18 GMT

Found my solution. Just added System.Data.SQLite to my project and performed a query directly to the SQLite database to get the indexes present.

string dataSource = @"c:\MyDatabase.geodatabase";

SQLiteConnection sqlCon = new SQLiteConnection("Data Source=" + dataSource + ";Version=3;");

sqlCon.Open();

string sqlQuery = "Select sql FROM SQLite_master WHERE type = 'index' AND tbl_name = 'MYTABLE'";

SQLiteCommand sqlCmd = new SQLiteCommand(sqlQuery, sqlCon);

SQLiteDataReader sqlRead = sqlCmd.ExecuteReader();

string result = "";

while (sqlRead.Read())

{

result += sqlRead[0].ToString() + Environment.NewLine;

}

topic Detecting the presence of an attribute index on a runtime geodatabase class in .NET Maps SDK Questions

Detecting the presence of an attribute index on a runtime geodatabase class

Re: Detecting the presence of an attribute index on a runtime geodatabase class