ThinkGeo.Core.SqliteFeatureSource
Inheritance Hierarchy
Members Summary
Public Constructors
SqliteFeatureSource()
Parameters
SqliteFeatureSource(String,String,String,String)
Parameters
connectionString
Type:String
Description:N/A
tableName
Type:String
Description:N/A
featureIdColumn
Type:String
Description:N/A
geometryColumnName
Type:String
Description:N/A
SqliteFeatureSource(SqliteConnection,String,String,String)
Parameters
connection
Type:SqliteConnection
Description:N/A
tableName
Type:String
Description:N/A
featureIdColumn
Type:String
Description:N/A
geometryColumnName
Type:String
Description:N/A
SqliteFeatureSource(SqliteConnection,String)
Parameters
connection
Type:SqliteConnection
Description:N/A
tableName
Type:String
Description:N/A
SqliteFeatureSource(String,String)
Parameters
connectionString
Type:String
Description:N/A
tableName
Type:String
Description:N/A
Protected Constructors
Public Methods
GetDistinctColumnValues(String)
Return Value
Parameters
columnName
Type:String
Description:N/A
GetAllFeatures(ReturningColumnsType,Int32)
Return Value
Parameters
startIndex
Type:Int32
Description:N/A
GetAllFeatures(ReturningColumnsType,Int32,Int32)
Return Value
Parameters
startIndex
Type:Int32
Description:N/A
takeCount
Type:Int32
Description:N/A
GetAllFeatures(IEnumerable<String>,Int32,Int32)
Return Value
Parameters
returningColumnNames
Type:IEnumerable<String>
Description:N/A
startIndex
Type:Int32
Description:N/A
takeCount
Type:Int32
Description:N/A
CommitTransaction()
Return Value
Parameters
AddColumn(FeatureSourceColumn)
Return Value
Type:Void
Description:N/A
Parameters
DeleteColumn(String)
Return Value
Type:Void
Description:N/A
Parameters
columnName
Type:String
Description:N/A
UpdateColumn(String,FeatureSourceColumn)
Return Value
Type:Void
Description:N/A
Parameters
columnName
Type:String
Description:N/A
GetAllFeatures(IEnumerable<String>)
Return Value
Parameters
returningColumnNames
Type:IEnumerable<String>
Description:N/A
GetAllFeatures(ReturningColumnsType)
Return Value
Parameters
GetFeatureIds()
Return Value
Type:Collection<String>
Description:N/A
Parameters
GetFeaturesOutsideBoundingBox(RectangleShape,IEnumerable<String>)
Return Value
Parameters
returningColumnNames
Type:IEnumerable<String>
Description:N/A
GetFeaturesOutsideBoundingBox(RectangleShape,ReturningColumnsType)
Return Value
Parameters
GetFeaturesInsideBoundingBox(RectangleShape,IEnumerable<String>)
Return Value
Parameters
returningColumnNames
Type:IEnumerable<String>
Description:N/A
GetFeaturesInsideBoundingBox(RectangleShape,ReturningColumnsType)
Return Value
Parameters
GetFeatureIdsInsideBoundingBox(RectangleShape)
Return Value
Type:Collection<String>
Description:N/A
Parameters
GetFeaturesForDrawing(RectangleShape,Double,Double,IEnumerable<String>)
Return Value
Parameters
screenWidth
Type:Double
Description:N/A
screenHeight
Type:Double
Description:N/A
returningColumnNames
Type:IEnumerable<String>
Description:N/A
GetFeaturesForDrawing(RectangleShape,Double,Double,ReturningColumnsType)
Return Value
Parameters
screenWidth
Type:Double
Description:N/A
screenHeight
Type:Double
Description:N/A
SpatialQuery(BaseShape,QueryType,IEnumerable<String>)
Return Value
Parameters
returningColumnNames
Type:IEnumerable<String>
Description:N/A
SpatialQuery(BaseShape,QueryType,ReturningColumnsType)
Return Value
Parameters
SpatialQuery(Feature,QueryType,IEnumerable<String>)
Return Value
Parameters
returningColumnNames
Type:IEnumerable<String>
Description:N/A
SpatialQuery(Feature,QueryType,ReturningColumnsType)
Return Value
Parameters
GetFeaturesNearestTo(BaseShape,GeographyUnit,Int32,IEnumerable<String>)
Return Value
Parameters
maxItemsToFind
Type:Int32
Description:N/A
returningColumnNames
Type:IEnumerable<String>
Description:N/A
GetFeaturesNearestTo(BaseShape,GeographyUnit,Int32,ReturningColumnsType)
Return Value
Parameters
maxItemsToFind
Type:Int32
Description:N/A
GetFeaturesNearestTo(Feature,GeographyUnit,Int32,IEnumerable<String>)
Return Value
Parameters
maxItemsToFind
Type:Int32
Description:N/A
returningColumnNames
Type:IEnumerable<String>
Description:N/A
GetFeaturesNearestTo(Feature,GeographyUnit,Int32,ReturningColumnsType)
Return Value
Parameters
maxItemsToFind
Type:Int32
Description:N/A
GetFeaturesNearestTo(BaseShape,GeographyUnit,Int32,IEnumerable<String>,Double,DistanceUnit)
Return Value
Parameters
maxItemsToFind
Type:Int32
Description:N/A
returningColumnNames
Type:IEnumerable<String>
Description:N/A
searchRadius
Type:Double
Description:N/A
GetFeaturesNearestTo(Feature,GeographyUnit,Int32,IEnumerable<String>,Double,DistanceUnit)
Return Value
Parameters
maxItemsToFind
Type:Int32
Description:N/A
returningColumnNames
Type:IEnumerable<String>
Description:N/A
searchRadius
Type:Double
Description:N/A
GetFeaturesWithinDistanceOf(BaseShape,GeographyUnit,DistanceUnit,Double,IEnumerable<String>)
Return Value
Parameters
distance
Type:Double
Description:N/A
returningColumnNames
Type:IEnumerable<String>
Description:N/A
GetFeaturesWithinDistanceOf(BaseShape,GeographyUnit,DistanceUnit,Double,ReturningColumnsType)
Return Value
Parameters
distance
Type:Double
Description:N/A
GetFeaturesWithinDistanceOf(Feature,GeographyUnit,DistanceUnit,Double,IEnumerable<String>)
Return Value
Parameters
distance
Type:Double
Description:N/A
returningColumnNames
Type:IEnumerable<String>
Description:N/A
GetFeaturesWithinDistanceOf(Feature,GeographyUnit,DistanceUnit,Double,ReturningColumnsType)
Return Value
Parameters
distance
Type:Double
Description:N/A
GetFeatureById(String,IEnumerable<String>)
Return Value
Parameters
id
Type:String
Description:N/A
returningColumnNames
Type:IEnumerable<String>
Description:N/A
GetFeatureById(String,ReturningColumnsType)
Return Value
Parameters
id
Type:String
Description:N/A
GetFeaturesByIds(IEnumerable<String>,IEnumerable<String>)
Return Value
Parameters
ids
Type:IEnumerable<String>
Description:N/A
returningColumnNames
Type:IEnumerable<String>
Description:N/A
GetFeaturesByIds(IEnumerable<String>,ReturningColumnsType)
Return Value
Parameters
ids
Type:IEnumerable<String>
Description:N/A
GetBoundingBoxById(String)
Return Value
Parameters
id
Type:String
Description:N/A
GetBoundingBoxByIds(IEnumerable<String>)
Return Value
Parameters
ids
Type:IEnumerable<String>
Description:N/A
RemoveEmptyAndExcludedFeatures(Collection<Feature>)
Return Value
Type:Void
Description:N/A
Parameters
GetColumnNamesOutsideFeatureSource(IEnumerable<String>)
Return Value
Type:Collection<String>
Description:N/A
Parameters
returningColumnNames
Type:IEnumerable<String>
Description:N/A
GetBoundingBoxesByIds(IEnumerable<String>)
Return Value
Parameters
ids
Type:IEnumerable<String>
Description:N/A
GetFirstFeaturesWellKnownType()
Return Value
Parameters
CanGetBoundingBoxQuickly()
Return Value
Type:Boolean
Description:N/A
Parameters
CanGetCountQuickly()
Return Value
Type:Boolean
Description:N/A
Parameters
ExecuteNonQuery(String)
Return Value
Type:Int32
Description:N/A
Parameters
sqlStatement
Type:String
Description:N/A
GetFeaturesByColumnValue(String,String,ReturningColumnsType)
Return Value
Parameters
columnName
Type:String
Description:N/A
columnValue
Type:String
Description:N/A
GetFeaturesByColumnValue(String,String,IEnumerable<String>)
Return Value
Parameters
columnName
Type:String
Description:N/A
columnValue
Type:String
Description:N/A
returningColumnNames
Type:IEnumerable<String>
Description:N/A
GetFeaturesByColumnValue(String,String)
Return Value
Parameters
columnName
Type:String
Description:N/A
columnValue
Type:String
Description:N/A
ExecuteScalar(String)
Return Value
Type:Object
Description:N/A
Parameters
sqlStatement
Type:String
Description:N/A
ExecuteQuery(String)
Return Value
Type:DataTable
Description:N/A
Parameters
sqlStatement
Type:String
Description:N/A
GetColumns()
Return Value
Parameters
RefreshColumns()
Return Value
Type:Void
Description:N/A
Parameters
GetCount()
Return Value
Type:Int64
Description:N/A
Parameters
GetBoundingBox()
Return Value
Parameters
CloneDeep()
Return Value
Parameters
Open()
Return Value
Type:Void
Description:N/A
Parameters
Close()
Return Value
Type:Void
Description:N/A
Parameters
BeginTransaction()
Return Value
Type:Void
Description:N/A
Parameters
AddFeature(Feature)
Return Value
Type:String
Description:N/A
Parameters
AddFeature(BaseShape)
Return Value
Type:String
Description:N/A
Parameters
AddFeature(BaseShape,IDictionary<String,String>)
Return Value
Type:String
Description:N/A
Parameters
DeleteFeature(String)
Return Value
Type:Void
Description:N/A
Parameters
id
Type:String
Description:N/A
UpdateFeature(Feature)
Return Value
Type:Void
Description:N/A
Parameters
UpdateFeature(BaseShape)
Return Value
Type:Void
Description:N/A
Parameters
UpdateFeature(BaseShape,IDictionary<String,String>)
Return Value
Type:Void
Description:N/A
Parameters
RollbackTransaction()
Return Value
Type:Void
Description:N/A
Parameters
GetType()
Return Value
Type:Type
Description:N/A
Parameters
ToString()
Return Value
Type:String
Description:N/A
Parameters
Equals(Object)
Return Value
Type:Boolean
Description:N/A
Parameters
obj
Type:Object
Description:N/A
GetHashCode()
Return Value
Type:Int32
Description:N/A
Parameters
CreateTable(SqliteConnection,String,IEnumerable<SqliteColumn>,GeographyUnit)
Return Value
Type:Void
Description:N/A
Parameters
connection
Type:SqliteConnection
Description:N/A
CreateTable(String,String,IEnumerable<SqliteColumn>,GeographyUnit)
Return Value
Type:Void
Description:N/A
Parameters
CreateView(SqliteConnection,String,String,String,GeographyUnit,String)
Return Value
Type:Void
Description:N/A
Parameters
connection
Type:SqliteConnection
Description:N/A
geometryColumnName
Type:String
Description:N/A
CreateView(SqliteConnection,String,String,String,GeographyUnit)
Return Value
Type:Void
Description:N/A
Parameters
connection
Type:SqliteConnection
Description:N/A
viewName
Type:String
Description:N/A
createViewSql
Type:String
Description:N/A
featureIdColumn
Type:String
Description:N/A
CreateView(String,String,String,String,GeographyUnit)
Return Value
Type:Void
Description:N/A
Parameters
CreateDatabase(String)
Return Value
Type:Void
Description:N/A
Parameters
databasePathFilename
Type:String
Description:N/A
GetColumnNames(String,String)
Return Value
Type:Collection<String>
Description:N/A
Parameters
connectionString
Type:String
Description:N/A
tableName
Type:String
Description:N/A
GetTableNames(String)
Return Value
Type:Collection<String>
Description:N/A
Parameters
connectionString
Type:String
Description:N/A
CreateSpatialIndex(SqliteConnection,String,String,Int32)
Return Value
Type:Boolean
Description:N/A
Parameters
SqliteConnection
Type:SqliteConnection
Description:N/A
tableName
Type:String
Description:N/A
geometryColumnName
Type:String
Description:N/A
srid
Type:Int32
Description:N/A
Protected Methods
OnExecutingSqlStatement(ExecutingSqlStatementSqliteFeatureSourceEventArgs)
Return Value
Type:Void
Description:N/A
Parameters
ExecuteNonQueryCore(String)
Return Value
Type:Int32
Description:N/A
Parameters
sqlStatement
Type:String
Description:N/A
GetFirstFeaturesWellKnownTypeCore()
Return Value
Parameters
OpenCore()
Return Value
Type:Void
Description:N/A
Parameters
CloseCore()
Return Value
Type:Void
Description:N/A
Parameters
GetCountCore()
Return Value
Type:Int64
Description:N/A
Parameters
GetFeaturesInsideBoundingBoxCore(RectangleShape,IEnumerable<String>)
Return Value
Parameters
returningColumnNames
Type:IEnumerable<String>
Description:N/A
GetFeaturesOutsideBoundingBoxCore(RectangleShape,IEnumerable<String>)
Return Value
Parameters
returningColumnNames
Type:IEnumerable<String>
Description:N/A
CommitTransactionCore(TransactionBuffer)
Return Value
Parameters
GetAllFeaturesCore(IEnumerable<String>)
Return Value
Parameters
columnNames
Type:IEnumerable<String>
Description:N/A
GetColumnsCore()
Return Value
Parameters
CanGetBoundingBoxQuicklyCore()
Return Value
Type:Boolean
Description:N/A
Parameters
GetBoundingBoxCore()
Return Value
Parameters
GetFeaturesByIdsCore(IEnumerable<String>,IEnumerable<String>)
Return Value
Parameters
ids
Type:IEnumerable<String>
Description:N/A
returningColumnNames
Type:IEnumerable<String>
Description:N/A
GetFeaturesByColumnValueCore(String,String,IEnumerable<String>)
Return Value
Parameters
columnName
Type:String
Description:N/A
columnValue
Type:String
Description:N/A
returningColumnNames
Type:IEnumerable<String>
Description:N/A
ExecuteQueryCore(String)
Return Value
Type:DataTable
Description:N/A
Parameters
sqlStatement
Type:String
Description:N/A
GetFeatureIdsCore()
Return Value
Type:Collection<String>
Description:N/A
Parameters
GetFeatureIdsInsideBoundingBoxCore(RectangleShape)
Return Value
Type:Collection<String>
Description:N/A
Parameters
GetDistinctColumnValuesCore(String)
Return Value
Parameters
columnName
Type:String
Description:N/A
GetAllFeaturesCore(IEnumerable<String>,Int32,Int32)
Return Value
Parameters
returningColumnNames
Type:IEnumerable<String>
Description:N/A
startIndex
Type:Int32
Description:N/A
takeCount
Type:Int32
Description:N/A
RaiseCustomColumnFetchEvent(Collection<Feature>,Collection<String>)
Return Value
Parameters
ProcessTransaction(RectangleShape,Collection<Feature>,Boolean)
Return Value
Type:Void
Description:N/A
Parameters
needUpdateProjection
Type:Boolean
Description:N/A
GetFeaturesForDrawingCore(RectangleShape,Double,Double,IEnumerable<String>)
Return Value
Parameters
screenWidth
Type:Double
Description:N/A
screenHeight
Type:Double
Description:N/A
returningColumnNames
Type:IEnumerable<String>
Description:N/A
SpatialQueryCore(BaseShape,QueryType,IEnumerable<String>)
Return Value
Parameters
returningColumnNames
Type:IEnumerable<String>
Description:N/A
GetFeaturesNearestToCore(BaseShape,GeographyUnit,Int32,IEnumerable<String>)
Return Value
Parameters
maxItemsToFind
Type:Int32
Description:N/A
returningColumnNames
Type:IEnumerable<String>
Description:N/A
GetFeaturesWithinDistanceOfCore(BaseShape,GeographyUnit,DistanceUnit,Double,IEnumerable<String>)
Return Value
Parameters
distance
Type:Double
Description:N/A
returningColumnNames
Type:IEnumerable<String>
Description:N/A
GetBoundingBoxByIdCore(String)
Return Value
Parameters
id
Type:String
Description:N/A
GetColumnNamesInsideFeatureSource(IEnumerable<String>)
Return Value
Type:Collection<String>
Description:N/A
Parameters
returningColumnNames
Type:IEnumerable<String>
Description:N/A
GetReturningColumnNames(ReturningColumnsType)
Return Value
Type:Collection<String>
Description:N/A
Parameters
OnDrawingProgressChanged(DrawingProgressChangedEventArgs)
Return Value
Type:Void
Description:N/A
Parameters
GetColumnNamesOutsideFeatureSourceCall(IEnumerable<String>)
Return Value
Type:Collection<String>
Description:N/A
Parameters
returningColumnNames
Type:IEnumerable<String>
Description:N/A
CanGetCountQuicklyCore()
Return Value
Type:Boolean
Description:N/A
Parameters
OnGettingColumns(GettingColumnsFeatureSourceEventArgs)
Return Value
Type:Void
Description:N/A
Parameters
OnGottenColumns(GottenColumnsFeatureSourceEventArgs)
Return Value
Type:Void
Description:N/A
Parameters
OnCustomColumnFetch(CustomColumnFetchEventArgs)
Return Value
Type:Void
Description:N/A
Parameters
OnCommittingTransaction(CommittingTransactionEventArgs)
Return Value
Type:Void
Description:N/A
Parameters
OnCommittedTransaction(CommittedTransactionEventArgs)
Return Value
Type:Void
Description:N/A
Parameters
OnOpeningFeatureSource(OpeningFeatureSourceEventArgs)
Return Value
Type:Void
Description:N/A
Parameters
OnOpenedFeatureSource(OpenedFeatureSourceEventArgs)
Return Value
Type:Void
Description:N/A
Parameters
OnClosingFeatureSource(ClosingFeatureSourceEventArgs)
Return Value
Type:Void
Description:N/A
Parameters
OnClosedFeatureSource(ClosedFeatureSourceEventArgs)
Return Value
Type:Void
Description:N/A
Parameters
OnGettingFeaturesByIds(GettingFeaturesByIdsFeatureSourceEventArgs)
Return Value
Type:Void
Description:N/A
Parameters
OnGettingFeaturesForDrawing(GettingFeaturesForDrawingFeatureSourceEventArgs)
Return Value
Type:Void
Description:N/A
Parameters
ExecuteScalarCore(String)
Return Value
Type:Object
Description:N/A
Parameters
sqlStatement
Type:String
Description:N/A
CloneDeepCore()
Return Value
Parameters
MemberwiseClone()
Return Value
Type:Object
Description:N/A
Parameters
Finalize()
Return Value
Type:Void
Description:N/A
Parameters
Public Properties
FetchTime
Return Value
DrawnFeatureCount
Return Value
TotalBytesDrawn
Return Value
WhereClause
Return Value
CommandTimeout
Return Value
GeometryColumnName
Return Value
ConnectionString
Return Value
TableName
Return Value
FeatureIdColumn
Return Value
IsEditable
Return Value
AlternateGeometryIndexTableName
Return Value
Id
Return Value
CanExecuteSqlQuery
Return Value
IsOpen
Return Value
Projection
Return Value
CanModifyColumnStructure
Return Value
IsInTransaction
Return Value
IsTransactionLive
Return Value
ProjectionConverter
Return Value
GeoCache
Return Value
FeatureIdsToExclude
Return Value
TransactionBuffer
Return Value
MaxRecordsToDraw
Return Value
Protected Properties
CanExecuteSqlQueryCore
Return Value
IsOpenCore
Return Value
CanModifyColumnStructureCore
Return Value
FeatureSourceColumns
Return Value
Public Events
ExecutingSqlStatement