ThinkGeo Cloud
ThinkGeo UI Controls
ThinkGeo Open Source
Help and Support
External Resources
Sidebar
thinkgeo.mapsuite.core.sqlitefeaturesource
Table of Contents
ThinkGeo.MapSuite.Core.SqliteFeatureSource
Note: The page was created before Map Suite 10. Map Suite 10.0 organized many classes into new namespaces and assemblies as well as had a few minor breaks in compatibility. The majority of previously built code should work without modification assuming the new namespaces are added. For guidance on upgrading your existing code, please check out MapSuite 10 Upgrade Guide.
Inheritance Hierarchy
Members Summary
Public Constructors
| Name | Parameters | DeclaringType | Summary |
|---|---|---|---|
 SqliteFeatureSource | |||
| SqliteFeatureSource | String, String, String, String | ||
| SqliteFeatureSource | SQLiteConnection, String, String, String |
Protected Constructors
| Name | Parameters | DeclaringType | Summary |
|---|
Public Methods
Protected Methods
Public Properties
| Name | Return | DeclaringType | Summary |
|---|---|---|---|
 CanExecuteSqlQuery | Boolean | FeatureSource | |
| CanModifyColumnStructure | Boolean | FeatureSource | |
| CommandTimeout | Int32 | ||
| ConnectionString | String | ||
| DrawnFeatureCount | Int32 | ||
| FeatureIdColumn | String | ||
| FeatureIdsToExclude | Collection<String> | FeatureSource | |
| FetchTime | Double | ||
| Filters | Collection<String> | FeatureSource | |
| GeoCache | FeatureCache | FeatureSource | |
| GeometryColumnName | String | ||
| Id | String | FeatureSource | |
| IsEditable | Boolean | FeatureSource(overriden) | |
| IsInTransaction | Boolean | FeatureSource | |
| IsOpen | Boolean | FeatureSource | |
| IsTransactionLive | Boolean | FeatureSource | |
| LinkExpressions | Collection<String> | FeatureSource | |
| LinkSources | Collection<LinkSource> | FeatureSource | |
| MaxRecordsToDraw | Int32 | FeatureSource | |
| Projection | Projection | FeatureSource | |
| TableName | String | ||
| TotalBytesDrawn | Int32 | ||
| TransactionBuffer | TransactionBuffer | FeatureSource | |
| WhereClause | String |
Protected Properties
| Name | Return | DeclaringType | Summary |
|---|---|---|---|
 CanExecuteSqlQueryCore | Boolean | FeatureSource(overriden) | |
| CanModifyColumnStructureCore | Boolean | FeatureSource | |
| IsOpenCore | Boolean | FeatureSource |
Public Events
Public Constructors
SqliteFeatureSource()
Parameters
| Name | Type | Description |
|---|
SqliteFeatureSource(String, String, String, String)
Parameters
| Name | Type | Description |
|---|---|---|
| connectionString | String | |
| tableName | String | |
| featureIdColumn | String | |
| geometryColumnName | String |
SqliteFeatureSource(SQLiteConnection, String, String, String)
Parameters
| Name | Type | Description |
|---|---|---|
| connection | SQLiteConnection | |
| tableName | String | |
| featureIdColumn | String | |
| geometryColumnName | String |
Protected Constructors
Public Methods
AddColumn(FeatureSourceColumn)
Return Value
| Return Type | Description |
|---|---|
| Void |
Parameters
| Name | Type | Description |
|---|---|---|
| featureSourceColumn | FeatureSourceColumn |
AddFeature(Feature)
Return Value
| Return Type | Description |
|---|---|
| String |
Parameters
AddFeature(BaseShape, IDictionary<String, String>)
Return Value
| Return Type | Description |
|---|---|
| String |
Parameters
AddFeature(BaseShape)
Return Value
| Return Type | Description |
|---|---|
| String |
Parameters
ApplyFilters(IEnumerable<Feature>, IEnumerable<String>, IEnumerable<String>)
Return Value
| Return Type | Description |
|---|---|
| Collection<Feature> |
Parameters
| Name | Type | Description |
|---|---|---|
| features | IEnumerable<Feature> | |
| returningColumnNames | IEnumerable<String> | |
| filters | IEnumerable<String> |
BeginTransaction()
Return Value
| Return Type | Description |
|---|---|
| Void |
Parameters
| Name | Type | Description |
|---|
CanGetBoundingBoxQuickly()
Return Value
| Return Type | Description |
|---|---|
| Boolean |
Parameters
| Name | Type | Description |
|---|
CanGetCountQuickly()
Return Value
| Return Type | Description |
|---|---|
| Boolean |
Parameters
| Name | Type | Description |
|---|
CloneDeep()
Return Value
| Return Type | Description |
|---|---|
| FeatureSource |
Parameters
| Name | Type | Description |
|---|
Close()
Return Value
| Return Type | Description |
|---|---|
| Void |
Parameters
| Name | Type | Description |
|---|
CommitTransaction()
Return Value
| Return Type | Description |
|---|---|
| TransactionResult |
Parameters
| Name | Type | Description |
|---|
CreateDatabase(String)
Return Value
| Return Type | Description |
|---|---|
| Void |
Parameters
| Name | Type | Description |
|---|---|---|
| databasePathFileName | String |
CreateSpatialIndex(SQLiteConnection, String, String, Int32)
Return Value
| Return Type | Description |
|---|---|
| Boolean |
Parameters
| Name | Type | Description |
|---|---|---|
| sqliteConnection | SQLiteConnection | |
| tableName | String | |
| geometryColumnName | String | |
| srid | Int32 |
DeleteColumn(String)
Return Value
| Return Type | Description |
|---|---|
| Void |
Parameters
| Name | Type | Description |
|---|---|---|
| columnName | String |
DeleteFeature(String)
Return Value
| Return Type | Description |
|---|---|
| Void |
Parameters
| Name | Type | Description |
|---|---|---|
| id | String |
Equals(Object)
Return Value
| Return Type | Description |
|---|---|
| Boolean |
Parameters
| Name | Type | Description |
|---|---|---|
| obj | Object |
ExecuteNonQuery(String)
Return Value
| Return Type | Description |
|---|---|
| Int32 |
Parameters
| Name | Type | Description |
|---|---|---|
| sqlStatement | String |
ExecuteQuery(String)
Return Value
| Return Type | Description |
|---|---|
| DataTable |
Parameters
| Name | Type | Description |
|---|---|---|
| sqlStatement | String |
ExecuteScalar(String)
Return Value
| Return Type | Description |
|---|---|
| Object |
Parameters
| Name | Type | Description |
|---|---|---|
| sqlStatement | String |
GetAllFeatures(IEnumerable<String>, Int32, Int32)
Return Value
| Return Type | Description |
|---|---|
| Collection<Feature> |
Parameters
| Name | Type | Description |
|---|---|---|
| returningColumnNames | IEnumerable<String> | |
| startIndex | Int32 | |
| takeCount | Int32 |
GetAllFeatures(IEnumerable<String>)
Return Value
| Return Type | Description |
|---|---|
| Collection<Feature> |
Parameters
| Name | Type | Description |
|---|---|---|
| returningColumnNames | IEnumerable<String> |
GetAllFeatures(ReturningColumnsType)
Return Value
| Return Type | Description |
|---|---|
| Collection<Feature> |
Parameters
| Name | Type | Description |
|---|---|---|
| returningColumnNamesType | ReturningColumnsType |
GetAllFeatures(ReturningColumnsType, Int32, Int32)
Return Value
| Return Type | Description |
|---|---|
| Collection<Feature> |
Parameters
| Name | Type | Description |
|---|---|---|
| returningColumnTypes | ReturningColumnsType | |
| startIndex | Int32 | |
| takeCount | Int32 |
GetAllFeatures(ReturningColumnsType, Int32)
Return Value
| Return Type | Description |
|---|---|
| Collection<Feature> |
Parameters
| Name | Type | Description |
|---|---|---|
| returningColumnTypes | ReturningColumnsType | |
| startIndex | Int32 |
GetBoundingBox()
Return Value
| Return Type | Description |
|---|---|
| RectangleShape |
Parameters
| Name | Type | Description |
|---|
GetBoundingBoxById(String)
Return Value
| Return Type | Description |
|---|---|
| RectangleShape |
Parameters
| Name | Type | Description |
|---|---|---|
| id | String |
GetBoundingBoxByIds(IEnumerable<String>)
Return Value
| Return Type | Description |
|---|---|
| RectangleShape |
Parameters
| Name | Type | Description |
|---|---|---|
| ids | IEnumerable<String> |
GetBoundingBoxesByIds(IEnumerable<String>)
Return Value
| Return Type | Description |
|---|---|
| Collection<RectangleShape> |
Parameters
| Name | Type | Description |
|---|---|---|
| ids | IEnumerable<String> |
GetColumnNames(String, String)
Return Value
| Return Type | Description |
|---|---|
| Collection<String> |
Parameters
| Name | Type | Description |
|---|---|---|
| connectionString | String | |
| tableName | String |
GetColumns()
Return Value
| Return Type | Description |
|---|---|
| Collection<FeatureSourceColumn> |
Parameters
| Name | Type | Description |
|---|
GetCount()
Return Value
| Return Type | Description |
|---|---|
| Int32 |
Parameters
| Name | Type | Description |
|---|
GetDistinctColumnValues(String)
Return Value
| Return Type | Description |
|---|---|
| Collection<DistinctColumnValue> |
Parameters
| Name | Type | Description |
|---|---|---|
| columnName | String |
GetFeatureById(String, ReturningColumnsType)
Return Value
| Return Type | Description |
|---|---|
| Feature |
Parameters
| Name | Type | Description |
|---|---|---|
| id | String | |
| returningColumnNamesType | ReturningColumnsType |
GetFeatureById(String, IEnumerable<String>)
Return Value
| Return Type | Description |
|---|---|
| Feature |
Parameters
| Name | Type | Description |
|---|---|---|
| id | String | |
| returningColumnNames | IEnumerable<String> |
GetFeaturesByColumnValue(String, String)
Return Value
| Return Type | Description |
|---|---|
| Collection<Feature> |
Parameters
| Name | Type | Description |
|---|---|---|
| columnName | String | |
| columnValue | String |
GetFeaturesByColumnValue(String, String, ReturningColumnsType)
Return Value
| Return Type | Description |
|---|---|
| Collection<Feature> |
Parameters
| Name | Type | Description |
|---|---|---|
| columnName | String | |
| columnValue | String | |
| returningColumnType | ReturningColumnsType |
GetFeaturesByColumnValue(String, String, IEnumerable<String>)
Return Value
| Return Type | Description |
|---|---|
| Collection<Feature> |
Parameters
| Name | Type | Description |
|---|---|---|
| columnName | String | |
| columnValue | String | |
| returningColumnNames | IEnumerable<String> |
GetFeaturesByIds(IEnumerable<String>, IEnumerable<String>)
Return Value
| Return Type | Description |
|---|---|
| Collection<Feature> |
Parameters
| Name | Type | Description |
|---|---|---|
| ids | IEnumerable<String> | |
| returningColumnNames | IEnumerable<String> |
GetFeaturesByIds(IEnumerable<String>, IEnumerable<String>, IEnumerable<String>)
Return Value
| Return Type | Description |
|---|---|
| Collection<Feature> |
Parameters
| Name | Type | Description |
|---|---|---|
| ids | IEnumerable<String> | |
| returningColumnNames | IEnumerable<String> | |
| filters | IEnumerable<String> |
GetFeaturesByIds(IEnumerable<String>, ReturningColumnsType)
Return Value
| Return Type | Description |
|---|---|
| Collection<Feature> |
Parameters
| Name | Type | Description |
|---|---|---|
| ids | IEnumerable<String> | |
| returningColumnNamesType | ReturningColumnsType |
GetFeaturesForDrawing(RectangleShape, Double, Double, IEnumerable<String>, IEnumerable<String>)
Return Value
| Return Type | Description |
|---|---|
| Collection<Feature> |
Parameters
| Name | Type | Description |
|---|---|---|
| boundingBox | RectangleShape | |
| screenWidth | Double | |
| screenHeight | Double | |
| returningColumnNames | IEnumerable<String> | |
| filters | IEnumerable<String> |
GetFeaturesForDrawing(RectangleShape, Double, Double, ReturningColumnsType)
Return Value
| Return Type | Description |
|---|---|
| Collection<Feature> |
Parameters
| Name | Type | Description |
|---|---|---|
| boundingBox | RectangleShape | |
| screenWidth | Double | |
| screenHeight | Double | |
| returningColumnNamesType | ReturningColumnsType |
GetFeaturesForDrawing(RectangleShape, Double, Double, IEnumerable<String>)
Return Value
| Return Type | Description |
|---|---|
| Collection<Feature> |
Parameters
| Name | Type | Description |
|---|---|---|
| boundingBox | RectangleShape | |
| screenWidth | Double | |
| screenHeight | Double | |
| returningColumnNames | IEnumerable<String> |
GetFeaturesInsideBoundingBox(RectangleShape, ReturningColumnsType)
Return Value
| Return Type | Description |
|---|---|
| Collection<Feature> |
Parameters
| Name | Type | Description |
|---|---|---|
| boundingBox | RectangleShape | |
| returningColumnNamesType | ReturningColumnsType |
GetFeaturesInsideBoundingBox(RectangleShape, IEnumerable<String>)
Return Value
| Return Type | Description |
|---|---|
| Collection<Feature> |
Parameters
| Name | Type | Description |
|---|---|---|
| boundingBox | RectangleShape | |
| returningColumnNames | IEnumerable<String> |
GetFeaturesNearestTo(BaseShape, GeographyUnit, Int32, IEnumerable<String>, Double, DistanceUnit)
Return Value
| Return Type | Description |
|---|---|
| Collection<Feature> |
Parameters
| Name | Type | Description |
|---|---|---|
| targetShape | BaseShape | |
| unitOfData | GeographyUnit | |
| maxItemsToFind | Int32 | |
| returningColumnNames | IEnumerable<String> | |
| searchRadius | Double | |
| unitOfSearchRadius | DistanceUnit |
GetFeaturesNearestTo(Feature, GeographyUnit, Int32, IEnumerable<String>, Double, DistanceUnit)
Return Value
| Return Type | Description |
|---|---|
| Collection<Feature> |
Parameters
| Name | Type | Description |
|---|---|---|
| targetFeature | Feature | |
| unitOfData | GeographyUnit | |
| maxItemsToFind | Int32 | |
| returningColumnNames | IEnumerable<String> | |
| searchRadius | Double | |
| unitOfSearchRadius | DistanceUnit |
GetFeaturesNearestTo(Feature, GeographyUnit, Int32, ReturningColumnsType)
Return Value
| Return Type | Description |
|---|---|
| Collection<Feature> |
Parameters
| Name | Type | Description |
|---|---|---|
| targetFeature | Feature | |
| unitOfData | GeographyUnit | |
| maxItemsToFind | Int32 | |
| returningColumnNamesType | ReturningColumnsType |
GetFeaturesNearestTo(Feature, GeographyUnit, Int32, IEnumerable<String>)
Return Value
| Return Type | Description |
|---|---|
| Collection<Feature> |
Parameters
| Name | Type | Description |
|---|---|---|
| targetFeature | Feature | |
| unitOfData | GeographyUnit | |
| maxItemsToFind | Int32 | |
| returningColumnNames | IEnumerable<String> |
GetFeaturesNearestTo(BaseShape, GeographyUnit, Int32, IEnumerable<String>)
Return Value
| Return Type | Description |
|---|---|
| Collection<Feature> |
Parameters
| Name | Type | Description |
|---|---|---|
| targetShape | BaseShape | |
| unitOfFeatureSource | GeographyUnit | |
| maxItemsToFind | Int32 | |
| returningColumnNames | IEnumerable<String> |
GetFeaturesNearestTo(BaseShape, GeographyUnit, Int32, ReturningColumnsType)
Return Value
| Return Type | Description |
|---|---|
| Collection<Feature> |
Parameters
| Name | Type | Description |
|---|---|---|
| targetShape | BaseShape | |
| unitOfData | GeographyUnit | |
| maxItemsToFind | Int32 | |
| returningColumnNamesType | ReturningColumnsType |
GetFeaturesOutsideBoundingBox(RectangleShape, ReturningColumnsType)
Return Value
| Return Type | Description |
|---|---|
| Collection<Feature> |
Parameters
| Name | Type | Description |
|---|---|---|
| boundingBox | RectangleShape | |
| returningColumnNamesType | ReturningColumnsType |
GetFeaturesOutsideBoundingBox(RectangleShape, IEnumerable<String>)
Return Value
| Return Type | Description |
|---|---|
| Collection<Feature> |
Parameters
| Name | Type | Description |
|---|---|---|
| boundingBox | RectangleShape | |
| returningColumnNames | IEnumerable<String> |
GetFeaturesWithinDistanceOf(BaseShape, GeographyUnit, DistanceUnit, Double, IEnumerable<String>)
Return Value
| Return Type | Description |
|---|---|
| Collection<Feature> |
Parameters
| Name | Type | Description |
|---|---|---|
| targetShape | BaseShape | |
| unitOfData | GeographyUnit | |
| distanceUnit | DistanceUnit | |
| distance | Double | |
| returningColumnNames | IEnumerable<String> |
GetFeaturesWithinDistanceOf(Feature, GeographyUnit, DistanceUnit, Double, IEnumerable<String>)
Return Value
| Return Type | Description |
|---|---|
| Collection<Feature> |
Parameters
| Name | Type | Description |
|---|---|---|
| targetFeature | Feature | |
| unitOfData | GeographyUnit | |
| distanceUnit | DistanceUnit | |
| distance | Double | |
| returningColumnNames | IEnumerable<String> |
GetFeaturesWithinDistanceOf(BaseShape, GeographyUnit, DistanceUnit, Double, ReturningColumnsType)
Return Value
| Return Type | Description |
|---|---|
| Collection<Feature> |
Parameters
| Name | Type | Description |
|---|---|---|
| targetShape | BaseShape | |
| unitOfData | GeographyUnit | |
| distanceUnit | DistanceUnit | |
| distance | Double | |
| returningColumnNamesType | ReturningColumnsType |
GetFeaturesWithinDistanceOf(Feature, GeographyUnit, DistanceUnit, Double, ReturningColumnsType)
Return Value
| Return Type | Description |
|---|---|
| Collection<Feature> |
Parameters
| Name | Type | Description |
|---|---|---|
| targetFeature | Feature | |
| unitOfData | GeographyUnit | |
| distanceUnit | DistanceUnit | |
| distance | Double | |
| returningColumnNamesType | ReturningColumnsType |
GetFirstFeaturesWellKnownType()
Return Value
| Return Type | Description |
|---|---|
| WellKnownType |
Parameters
| Name | Type | Description |
|---|
GetHashCode()
Return Value
| Return Type | Description |
|---|---|
| Int32 |
Parameters
| Name | Type | Description |
|---|
GetTableNames(String)
Return Value
| Return Type | Description |
|---|---|
| Collection<String> |
Parameters
| Name | Type | Description |
|---|---|---|
| connectionString | String |
GetType()
Return Value
| Return Type | Description |
|---|---|
| Type |
Parameters
| Name | Type | Description |
|---|
Open()
Return Value
| Return Type | Description |
|---|---|
| Void |
Parameters
| Name | Type | Description |
|---|
RefreshColumns()
Return Value
| Return Type | Description |
|---|---|
| Void |
Parameters
| Name | Type | Description |
|---|
RollbackTransaction()
Return Value
| Return Type | Description |
|---|---|
| Void |
Parameters
| Name | Type | Description |
|---|
SpatialQuery(Feature, QueryType, ReturningColumnsType)
Return Value
| Return Type | Description |
|---|---|
| Collection<Feature> |
Parameters
| Name | Type | Description |
|---|---|---|
| feature | Feature | |
| queryType | QueryType | |
| returningColumnNamesType | ReturningColumnsType |
SpatialQuery(BaseShape, QueryType, ReturningColumnsType)
Return Value
| Return Type | Description |
|---|---|
| Collection<Feature> |
Parameters
| Name | Type | Description |
|---|---|---|
| targetShape | BaseShape | |
| queryType | QueryType | |
| returningColumnNamesType | ReturningColumnsType |
SpatialQuery(Feature, QueryType, IEnumerable<String>)
Return Value
| Return Type | Description |
|---|---|
| Collection<Feature> |
Parameters
SpatialQuery(BaseShape, QueryType, IEnumerable<String>)
Return Value
| Return Type | Description |
|---|---|
| Collection<Feature> |
Parameters
SpatialQuery(BaseShape, QueryType, IEnumerable<String>, IEnumerable<String>)
Return Value
| Return Type | Description |
|---|---|
| Collection<Feature> |
Parameters
ToString()
Return Value
| Return Type | Description |
|---|---|
| String |
Parameters
| Name | Type | Description |
|---|
UpdateColumn(String, FeatureSourceColumn)
Return Value
| Return Type | Description |
|---|---|
| Void |
Parameters
| Name | Type | Description |
|---|---|---|
| columnName | String | |
| newFeatureSourceColumn | FeatureSourceColumn |
UpdateFeature(BaseShape, IDictionary<String, String>)
Return Value
| Return Type | Description |
|---|---|
| Void |
Parameters
UpdateFeature(Feature)
Return Value
| Return Type | Description |
|---|---|
| Void |
Parameters
UpdateFeature(BaseShape)
Return Value
| Return Type | Description |
|---|---|
| Void |
Parameters
Protected Methods
ApplyFiltersCore(IEnumerable<Feature>, IEnumerable<String>, String)
Return Value
| Return Type | Description |
|---|---|
| Collection<Feature> |
Parameters
| Name | Type | Description |
|---|---|---|
| features | IEnumerable<Feature> | |
| returningColumnNames | IEnumerable<String> | |
| linkExpression | String |
CanGetBoundingBoxQuicklyCore()
Return Value
| Return Type | Description |
|---|---|
| Boolean |
Parameters
| Name | Type | Description |
|---|
CanGetCountQuicklyCore()
Return Value
| Return Type | Description |
|---|---|
| Boolean |
Parameters
| Name | Type | Description |
|---|
CloneDeepCore()
Return Value
| Return Type | Description |
|---|---|
| FeatureSource |
Parameters
| Name | Type | Description |
|---|
CloseCore()
Return Value
| Return Type | Description |
|---|---|
| Void |
Parameters
| Name | Type | Description |
|---|
CommitTransactionCore(TransactionBuffer)
Return Value
| Return Type | Description |
|---|---|
| TransactionResult |
Parameters
| Name | Type | Description |
|---|---|---|
| transactions | TransactionBuffer |
ConvertToExternalProjection(IEnumerable<Feature>)
Return Value
| Return Type | Description |
|---|---|
| Collection<Feature> |
Parameters
ConvertToExternalProjection(IEnumerable<RectangleShape>)
Return Value
| Return Type | Description |
|---|---|
| Collection<RectangleShape> |
Parameters
| Name | Type | Description |
|---|---|---|
| rectangles | IEnumerable<RectangleShape> |
ConvertToExternalProjection(RectangleShape)
Return Value
| Return Type | Description |
|---|---|
| RectangleShape |
Parameters
| Name | Type | Description |
|---|---|---|
| rectangle | RectangleShape |
ConvertToExternalProjection(Feature)
Return Value
| Return Type | Description |
|---|---|
| Feature |
Parameters
ConvertToInternalProjection(IEnumerable<Feature>)
Return Value
| Return Type | Description |
|---|---|
| Collection<Feature> |
Parameters
ConvertToInternalProjection(Feature)
Return Value
| Return Type | Description |
|---|---|
| Feature |
Parameters
ConvertToInternalProjection(RectangleShape)
Return Value
| Return Type | Description |
|---|---|
| RectangleShape |
Parameters
| Name | Type | Description |
|---|---|---|
| rectangle | RectangleShape |
ConvertToInternalProjection(IEnumerable<RectangleShape>)
Return Value
| Return Type | Description |
|---|---|
| Collection<RectangleShape> |
Parameters
| Name | Type | Description |
|---|---|---|
| rectangles | IEnumerable<RectangleShape> |
ConvertToInternalProjection(BaseShape)
Return Value
| Return Type | Description |
|---|---|
| BaseShape |
Parameters
ExecuteNonQueryCore(String)
Return Value
| Return Type | Description |
|---|---|
| Int32 |
Parameters
| Name | Type | Description |
|---|---|---|
| sqlStatement | String |
ExecuteQueryCore(String)
Return Value
| Return Type | Description |
|---|---|
| DataTable |
Parameters
| Name | Type | Description |
|---|---|---|
| sqlStatement | String |
ExecuteScalarCore(String)
Return Value
| Return Type | Description |
|---|---|
| Object |
Parameters
| Name | Type | Description |
|---|---|---|
| sqlStatement | String |
Finalize()
Return Value
| Return Type | Description |
|---|---|
| Void |
Parameters
| Name | Type | Description |
|---|
GetAllFeaturesCore(IEnumerable<String>, Int32, Int32)
Return Value
| Return Type | Description |
|---|---|
| Collection<Feature> |
Parameters
| Name | Type | Description |
|---|---|---|
| returningColumnNames | IEnumerable<String> | |
| startIndex | Int32 | |
| takeCount | Int32 |
GetAllFeaturesCore(IEnumerable<String>)
Return Value
| Return Type | Description |
|---|---|
| Collection<Feature> |
Parameters
| Name | Type | Description |
|---|---|---|
| columnNames | IEnumerable<String> |
GetBoundingBoxByIdCore(String)
Return Value
| Return Type | Description |
|---|---|
| RectangleShape |
Parameters
| Name | Type | Description |
|---|---|---|
| id | String |
GetBoundingBoxCore()
Return Value
| Return Type | Description |
|---|---|
| RectangleShape |
Parameters
| Name | Type | Description |
|---|
GetColumnNamesInsideFeatureSource(IEnumerable<String>)
Return Value
| Return Type | Description |
|---|---|
| Collection<String> |
Parameters
| Name | Type | Description |
|---|---|---|
| returningColumnNames | IEnumerable<String> |
GetColumnNamesOutsideFeatureSource(IEnumerable<String>)
Return Value
| Return Type | Description |
|---|---|
| Collection<String> |
Parameters
| Name | Type | Description |
|---|---|---|
| returningColumnNames | IEnumerable<String> |
GetColumnsCore()
Return Value
| Return Type | Description |
|---|---|
| Collection<FeatureSourceColumn> |
Parameters
| Name | Type | Description |
|---|
GetCountCore()
Return Value
| Return Type | Description |
|---|---|
| Int32 |
Parameters
| Name | Type | Description |
|---|
GetDistinctColumnValuesCore(String)
Return Value
| Return Type | Description |
|---|---|
| Collection<DistinctColumnValue> |
Parameters
| Name | Type | Description |
|---|---|---|
| columnName | String |
GetFeaturesByColumnValueCore(String, String, IEnumerable<String>)
Return Value
| Return Type | Description |
|---|---|
| Collection<Feature> |
Parameters
| Name | Type | Description |
|---|---|---|
| columnName | String | |
| columnValue | String | |
| returningColumnNames | IEnumerable<String> |
GetFeaturesByIdsCore(IEnumerable<String>, IEnumerable<String>)
Return Value
| Return Type | Description |
|---|---|
| Collection<Feature> |
Parameters
| Name | Type | Description |
|---|---|---|
| ids | IEnumerable<String> | |
| returningColumnNames | IEnumerable<String> |
GetFeaturesForDrawingCore(RectangleShape, Double, Double, IEnumerable<String>)
Return Value
| Return Type | Description |
|---|---|
| Collection<Feature> |
Parameters
| Name | Type | Description |
|---|---|---|
| boundingBox | RectangleShape | |
| screenWidth | Double | |
| screenHeight | Double | |
| returningColumnNames | IEnumerable<String> |
GetFeaturesInsideBoundingBoxCore(RectangleShape, IEnumerable<String>)
Return Value
| Return Type | Description |
|---|---|
| Collection<Feature> |
Parameters
| Name | Type | Description |
|---|---|---|
| boundingBox | RectangleShape | |
| returningColumnNames | IEnumerable<String> |
GetFeaturesNearestToCore(BaseShape, GeographyUnit, Int32, IEnumerable<String>)
Return Value
| Return Type | Description |
|---|---|
| Collection<Feature> |
Parameters
| Name | Type | Description |
|---|---|---|
| targetShape | BaseShape | |
| unitOfData | GeographyUnit | |
| maxItemsToFind | Int32 | |
| returningColumnNames | IEnumerable<String> |
GetFeaturesOutsideBoundingBoxCore(RectangleShape, IEnumerable<String>)
Return Value
| Return Type | Description |
|---|---|
| Collection<Feature> |
Parameters
| Name | Type | Description |
|---|---|---|
| boundingBox | RectangleShape | |
| returningColumnNames | IEnumerable<String> |
GetFeaturesWithinDistanceOfCore(BaseShape, GeographyUnit, DistanceUnit, Double, IEnumerable<String>)
Return Value
| Return Type | Description |
|---|---|
| Collection<Feature> |
Parameters
| Name | Type | Description |
|---|---|---|
| targetShape | BaseShape | |
| unitOfData | GeographyUnit | |
| distanceUnit | DistanceUnit | |
| distance | Double | |
| returningColumnNames | IEnumerable<String> |
GetFirstFeaturesWellKnownTypeCore()
Return Value
| Return Type | Description |
|---|---|
| WellKnownType |
Parameters
| Name | Type | Description |
|---|
GetReturningColumnNames(ReturningColumnsType)
Return Value
| Return Type | Description |
|---|---|
| Collection<String> |
Parameters
| Name | Type | Description |
|---|---|---|
| returningColumnNamesType | ReturningColumnsType |
MemberwiseClone()
Return Value
| Return Type | Description |
|---|---|
| Object |
Parameters
| Name | Type | Description |
|---|
OnAppliedFilters(AppliedFiltersFeatureSourceEventArgs)
Return Value
| Return Type | Description |
|---|---|
| Void |
Parameters
| Name | Type | Description |
|---|---|---|
| e | AppliedFiltersFeatureSourceEventArgs |
OnApplyingFilters(ApplyingFiltersFeatureSourceEventArgs)
Return Value
| Return Type | Description |
|---|---|
| Void |
Parameters
| Name | Type | Description |
|---|---|---|
| e | ApplyingFiltersFeatureSourceEventArgs |
OnClosedFeatureSource(ClosedFeatureSourceEventArgs)
Return Value
| Return Type | Description |
|---|---|
| Void |
Parameters
| Name | Type | Description |
|---|---|---|
| e | ClosedFeatureSourceEventArgs |
OnClosingFeatureSource(ClosingFeatureSourceEventArgs)
Return Value
| Return Type | Description |
|---|---|
| Void |
Parameters
| Name | Type | Description |
|---|---|---|
| e | ClosingFeatureSourceEventArgs |
OnCommittedTransaction(CommittedTransactionEventArgs)
Return Value
| Return Type | Description |
|---|---|
| Void |
Parameters
| Name | Type | Description |
|---|---|---|
| e | CommittedTransactionEventArgs |
OnCommittingTransaction(CommittingTransactionEventArgs)
Return Value
| Return Type | Description |
|---|---|
| Void |
Parameters
| Name | Type | Description |
|---|---|---|
| e | CommittingTransactionEventArgs |
OnCustomColumnFetch(CustomColumnFetchEventArgs)
Return Value
| Return Type | Description |
|---|---|
| Void |
Parameters
| Name | Type | Description |
|---|---|---|
| e | CustomColumnFetchEventArgs |
OnDrawingProgressChanged(DrawingProgressChangedEventArgs)
Return Value
| Return Type | Description |
|---|---|
| Void |
Parameters
| Name | Type | Description |
|---|---|---|
| e | DrawingProgressChangedEventArgs |
OnExecutingSqlStatement(ExecutingSqlStatementSqliteFeatureSourceEventArgs)
Return Value
| Return Type | Description |
|---|---|
| Void |
Parameters
| Name | Type | Description |
|---|---|---|
| e | ExecutingSqlStatementSqliteFeatureSourceEventArgs |
OnOpenedFeatureSource(OpenedFeatureSourceEventArgs)
Return Value
| Return Type | Description |
|---|---|
| Void |
Parameters
| Name | Type | Description |
|---|---|---|
| e | OpenedFeatureSourceEventArgs |
OnOpeningFeatureSource(OpeningFeatureSourceEventArgs)
Return Value
| Return Type | Description |
|---|---|
| Void |
Parameters
| Name | Type | Description |
|---|---|---|
| e | OpeningFeatureSourceEventArgs |
OpenCore()
Return Value
| Return Type | Description |
|---|---|
| Void |
Parameters
| Name | Type | Description |
|---|
SpatialQueryCore(BaseShape, QueryType, IEnumerable<String>)
Return Value
| Return Type | Description |
|---|---|
| Collection<Feature> |
Parameters
Public Properties
CanExecuteSqlQuery
Return Value
| Return Type |
|---|
| Boolean |
CanModifyColumnStructure
Return Value
| Return Type |
|---|
| Boolean |
CommandTimeout
Return Value
| Return Type |
|---|
| Int32 |
ConnectionString
Return Value
| Return Type |
|---|
| String |
DrawnFeatureCount
Return Value
| Return Type |
|---|
| Int32 |
FeatureIdColumn
Return Value
| Return Type |
|---|
| String |
FeatureIdsToExclude
Return Value
| Return Type |
|---|
| Collection<String> |
FetchTime
Return Value
| Return Type |
|---|
| Double |
Filters
Return Value
| Return Type |
|---|
| Collection<String> |
GeoCache
Return Value
| Return Type |
|---|
| FeatureCache |
GeometryColumnName
Return Value
| Return Type |
|---|
| String |
Id
Return Value
| Return Type |
|---|
| String |
IsEditable
Return Value
| Return Type |
|---|
| Boolean |
IsInTransaction
Return Value
| Return Type |
|---|
| Boolean |
IsOpen
Return Value
| Return Type |
|---|
| Boolean |
IsTransactionLive
Return Value
| Return Type |
|---|
| Boolean |
LinkExpressions
Return Value
| Return Type |
|---|
| Collection<String> |
LinkSources
Return Value
| Return Type |
|---|
| Collection<LinkSource> |
MaxRecordsToDraw
Return Value
| Return Type |
|---|
| Int32 |
Projection
Return Value
| Return Type |
|---|
| Projection |
TableName
Return Value
| Return Type |
|---|
| String |
TotalBytesDrawn
Return Value
| Return Type |
|---|
| Int32 |
TransactionBuffer
Return Value
| Return Type |
|---|
| TransactionBuffer |
WhereClause
Return Value
| Return Type |
|---|
| String |
Protected Properties
CanExecuteSqlQueryCore
Return Value
| Return Type |
|---|
| Boolean |
CanModifyColumnStructureCore
Return Value
| Return Type |
|---|
| Boolean |
IsOpenCore
Return Value
| Return Type |
|---|
| Boolean |
Public Events
AppliedFilters
Event Arguments
| Event Arguments |
|---|
| AppliedFiltersFeatureSourceEventArgs |
ApplyingFilters
Event Arguments
| Event Arguments |
|---|
| ApplyingFiltersFeatureSourceEventArgs |
ClosedFeatureSource
Event Arguments
| Event Arguments |
|---|
| ClosedFeatureSourceEventArgs |
ClosingFeatureSource
Event Arguments
| Event Arguments |
|---|
| ClosingFeatureSourceEventArgs |
CommittedTransaction
Event Arguments
| Event Arguments |
|---|
| CommittedTransactionEventArgs |
CommittingTransaction
Event Arguments
| Event Arguments |
|---|
| CommittingTransactionEventArgs |
CustomColumnFetch
Event Arguments
| Event Arguments |
|---|
| CustomColumnFetchEventArgs |
DrawingProgressChanged
Event Arguments
| Event Arguments |
|---|
| DrawingProgressChangedEventArgs |
ExecutingSqlStatement
Event Arguments
| Event Arguments |
|---|
| ExecutingSqlStatementSqliteFeatureSourceEventArgs |
OpenedFeatureSource
Event Arguments
| Event Arguments |
|---|
| OpenedFeatureSourceEventArgs |
OpeningFeatureSource
Event Arguments
| Event Arguments |
|---|
| OpeningFeatureSourceEventArgs |
NOTOC SQLiteExtension ThinkGeo.MapSuite.Core UpdateDocumentation
thinkgeo.mapsuite.core.sqlitefeaturesource.txt · Last modified: 2017/03/16 21:59 (external edit)