public Table OpenTable( QueryDescription queryDescription )
Public Function OpenTable( _ ByVal queryDescription As QueryDescription _ ) As Table
Parameters
- queryDescription
- The QueryDescription object.
public Table OpenTable( QueryDescription queryDescription )
Public Function OpenTable( _ ByVal queryDescription As QueryDescription _ ) As Table
Exception | Description |
---|---|
System.ArgumentNullException | queryDescription is null. |
ArcGIS.Core.Data.Exceptions.GeodatabaseException | A database-related exception has occurred. |
QueryDescription
. The first is created by GetQueryDescription(String). Given a table name (fully qualified or unqualified), it encapsulates all the important properties that describe the underlying single table (i.e., QueryDescription.IsQueryLayer returns false). The second flavor is created by GetQueryDescription(String,String). Given a valid SQL SELECT statement and a query layer name, it encapsulates all the important properties that describe the underlying query layer that is created from one or more tables (i.e., QueryDescription.IsQueryLayer returns true). If the table returned is a FeatureClass, the spatial type is taken from the first row returned. To remove ambiguity, QueryDescription.SetShapeType should be called prior to calling this routine.public async Task DefaultQueryDescription() { await ArcGIS.Desktop.Framework.Threading.Tasks.QueuedTask.Run(() => { DatabaseConnectionProperties databaseConnectionProperties = new DatabaseConnectionProperties(EnterpriseDatabaseType.SQLServer) { AuthenticationMode = AuthenticationMode.DBMS, Instance = "instance", Database = "database", User = "user", Password = "password" }; using (Database database = new Database(databaseConnectionProperties)) { QueryDescription queryDescription = database.GetQueryDescription("CUSTOMERS"); using (Table table = database.OpenTable(queryDescription)) { //use table } } }); }
public async Task CustomQueryDescription() { await ArcGIS.Desktop.Framework.Threading.Tasks.QueuedTask.Run(() => { DatabaseConnectionProperties databaseConnectionProperties = new DatabaseConnectionProperties(EnterpriseDatabaseType.SQLServer) { AuthenticationMode = AuthenticationMode.DBMS, Instance = "instance", Database = "database", User = "user", Password = "password" }; using (Database database = new Database(databaseConnectionProperties)) { QueryDescription queryDescription = database.GetQueryDescription("SELECT OBJECTID, Shape, FACILITYID FROM EmergencyFacility WHERE JURISDICT = 'Municipal'", "MunicipalEmergencyFacilities"); using (Table table = database.OpenTable(queryDescription)) { // Use the table. } } }); }
public async Task SqliteQueryDescription() { await ArcGIS.Desktop.Framework.Threading.Tasks.QueuedTask.Run(() => { using (Database database = new Database(new SQLiteConnectionPath(new Uri("Path\\To\\Sqlite\\Database\\USA.sqlite")))) { QueryDescription washingtonCitiesQueryDescription = database.GetQueryDescription("select OBJECTID, Shape, CITY_FIPS, CITY_NAME, STATE_FIPS, STATE_CITY, TYPE, CAPITAL from main.cities where STATE_NAME='Washington'", "WashingtonCities"); using (Table washingtonTable = database.OpenTable(washingtonCitiesQueryDescription)) { // Use washingtonTable. } } }); }
Target Platforms: Windows 11, Windows 10