Class SqliteFeatureSource

Namespace

ThinkGeo.Core

Assembly

ThinkGeo.Core.dll

This class represents a FeatureSource backed by SQLite.

[Obfuscation(Exclude = true)]
public class SqliteFeatureSource : FeatureSource

Inheritance

object

FeatureSource

SqliteFeatureSource

Inherited Members

FeatureSource.OnGettingColumns(GettingColumnsFeatureSourceEventArgs)

FeatureSource.OnGottenColumns(GottenColumnsFeatureSourceEventArgs)

FeatureSource.OnCustomColumnFetch(CustomColumnFetchEventArgs)

FeatureSource.OnCommittingTransaction(CommittingTransactionEventArgs)

FeatureSource.OnCommittedTransaction(CommittedTransactionEventArgs)

FeatureSource.OnOpeningFeatureSource(OpeningFeatureSourceEventArgs)

FeatureSource.OnOpenedFeatureSource(OpenedFeatureSourceEventArgs)

FeatureSource.OnClosingFeatureSource(ClosingFeatureSourceEventArgs)

FeatureSource.OnClosedFeatureSource(ClosedFeatureSourceEventArgs)

FeatureSource.OnGettingFeaturesByIds(GettingFeaturesByIdsFeatureSourceEventArgs)

FeatureSource.OnGettingFeaturesForDrawing(GettingFeaturesForDrawingFeatureSourceEventArgs)

FeatureSource.ExecuteNonQuery(string)

FeatureSource.GetFeaturesByColumnValue(string, string, ReturningColumnsType)

FeatureSource.GetFeaturesByColumnValue(string, string, IEnumerable<string>)

FeatureSource.GetFeaturesByColumnValue(string, string)

FeatureSource.ExecuteScalar(string)

FeatureSource.ExecuteScalarCore(string)

FeatureSource.ExecuteQuery(string)

FeatureSource.GetColumns()

FeatureSource.RefreshColumns()

FeatureSource.GetCount()

FeatureSource.GetBoundingBox()

FeatureSource.CloneDeep()

FeatureSource.CloneDeepCore()

FeatureSource.Open()

FeatureSource.Close()

FeatureSource.BeginTransaction()

FeatureSource.AddFeature(Feature)

FeatureSource.AddFeature(BaseShape)

FeatureSource.AddFeature(BaseShape, IDictionary<string, string>)

FeatureSource.DeleteFeature(string)

FeatureSource.UpdateFeature(Feature)

FeatureSource.UpdateFeature(BaseShape)

FeatureSource.UpdateFeature(BaseShape, IDictionary<string, string>)

FeatureSource.RollbackTransaction()

FeatureSource.CommitTransaction()

FeatureSource.AddColumn(FeatureSourceColumn)

FeatureSource.DeleteColumn(string)

FeatureSource.UpdateColumn(string, FeatureSourceColumn)

FeatureSource.GetAllFeatures(IEnumerable<string>)

FeatureSource.GetAllFeatures(ReturningColumnsType)

FeatureSource.GetFeatureIds()

FeatureSource.GetFeaturesOutsideBoundingBox(RectangleShape, IEnumerable<string>)

FeatureSource.GetFeaturesOutsideBoundingBox(RectangleShape, ReturningColumnsType)

FeatureSource.GetFeaturesInsideBoundingBox(RectangleShape, IEnumerable<string>)

FeatureSource.GetFeaturesInsideBoundingBox(RectangleShape, ReturningColumnsType)

FeatureSource.GetFeatureIdsInsideBoundingBox(RectangleShape)

FeatureSource.GetFeaturesForDrawing(RectangleShape, double, double, IEnumerable<string>)

FeatureSource.GetFeaturesForDrawing(RectangleShape, double, double, ReturningColumnsType)

FeatureSource.GetFeaturesForDrawingCore(RectangleShape, double, double, IEnumerable<string>)

FeatureSource.SpatialQuery(BaseShape, QueryType, IEnumerable<string>)

FeatureSource.SpatialQuery(BaseShape, QueryType, ReturningColumnsType)

FeatureSource.SpatialQuery(Feature, QueryType, IEnumerable<string>)

FeatureSource.SpatialQuery(Feature, QueryType, ReturningColumnsType)

FeatureSource.SpatialQueryCore(BaseShape, QueryType, IEnumerable<string>)

FeatureSource.GetFeaturesNearestTo(BaseShape, GeographyUnit, int, IEnumerable<string>)

FeatureSource.GetFeaturesNearestTo(BaseShape, GeographyUnit, int, ReturningColumnsType)

FeatureSource.GetFeaturesNearestTo(Feature, GeographyUnit, int, IEnumerable<string>)

FeatureSource.GetFeaturesNearestTo(Feature, GeographyUnit, int, ReturningColumnsType)

FeatureSource.GetFeaturesNearestTo(BaseShape, GeographyUnit, int, IEnumerable<string>, double, DistanceUnit)

FeatureSource.GetFeaturesNearestTo(Feature, GeographyUnit, int, IEnumerable<string>, double, DistanceUnit)

FeatureSource.GetFeaturesNearestToCore(BaseShape, GeographyUnit, int, IEnumerable<string>)

FeatureSource.GetFeaturesWithinDistanceOf(BaseShape, GeographyUnit, DistanceUnit, double, IEnumerable<string>)

FeatureSource.GetFeaturesWithinDistanceOf(BaseShape, GeographyUnit, DistanceUnit, double, ReturningColumnsType)

FeatureSource.GetFeaturesWithinDistanceOf(Feature, GeographyUnit, DistanceUnit, double, IEnumerable<string>)

FeatureSource.GetFeaturesWithinDistanceOf(Feature, GeographyUnit, DistanceUnit, double, ReturningColumnsType)

FeatureSource.GetFeaturesWithinDistanceOfCore(BaseShape, GeographyUnit, DistanceUnit, double, IEnumerable<string>)

FeatureSource.GetFeatureById(string, IEnumerable<string>)

FeatureSource.GetFeatureById(string, ReturningColumnsType)

FeatureSource.GetFeaturesByIds(IEnumerable<string>, IEnumerable<string>)

FeatureSource.GetFeaturesByIds(IEnumerable<string>, ReturningColumnsType)

FeatureSource.GetBoundingBoxById(string)

FeatureSource.GetBoundingBoxByIds(IEnumerable<string>)

FeatureSource.RemoveEmptyAndExcludedFeatures(Collection<Feature>)

FeatureSource.GetColumnNamesOutsideFeatureSource(IEnumerable<string>)

FeatureSource.GetBoundingBoxesByIds(IEnumerable<string>)

FeatureSource.GetBoundingBoxByIdCore(string)

FeatureSource.GetFirstFeaturesWellKnownType()

FeatureSource.GetColumnNamesInsideFeatureSource(IEnumerable<string>)

FeatureSource.GetReturningColumnNames(ReturningColumnsType)

FeatureSource.GetColumnNameAlias(string, ICollection<string>)

FeatureSource.SplitColumnNames(IEnumerable<string>)

FeatureSource.ConvertToDataTable(IEnumerable<Feature>, IEnumerable<string>)

FeatureSource.CombineFieldValues(Dictionary<string, string>, IEnumerable<string>)

FeatureSource.OnDrawingProgressChanged(DrawingProgressChangedEventArgs)

FeatureSource.CanGetBoundingBoxQuickly()

FeatureSource.CanGetCountQuickly()

FeatureSource.CanGetCountQuicklyCore()

FeatureSource.GetDistinctColumnValues(string)

FeatureSource.GetDistinctColumnValuesCore(string)

FeatureSource.GetAllFeatures(ReturningColumnsType, int)

FeatureSource.GetAllFeatures(ReturningColumnsType, int, int)

FeatureSource.GetAllFeatures(IEnumerable<string>, int, int)

FeatureSource.GetAllFeaturesCore(IEnumerable<string>, int, int)

FeatureSource.Id

FeatureSource.CanExecuteSqlQuery

FeatureSource.IsOpen

FeatureSource.Projection

FeatureSource.IsOpenCore

FeatureSource.CanModifyColumnStructure

FeatureSource.CanModifyColumnStructureCore

FeatureSource.FeatureSourceColumns

FeatureSource.IsInTransaction

FeatureSource.IsTransactionLive

FeatureSource.ProjectionConverter

FeatureSource.GeoCache

FeatureSource.FeatureIdsToExclude

FeatureSource.TransactionBuffer

FeatureSource.MaxRecordsToDraw

FeatureSource.DrawingProgressChanged

FeatureSource.GettingColumns

FeatureSource.GottenColumns

FeatureSource.GettingFeaturesByIds

FeatureSource.GettingFeaturesForDrawing

FeatureSource.CustomColumnFetch

FeatureSource.CommittingTransaction

FeatureSource.CommittedTransaction

FeatureSource.OpeningFeatureSource

FeatureSource.OpenedFeatureSource

FeatureSource.ClosingFeatureSource

FeatureSource.ClosedFeatureSource

object.GetType()

object.MemberwiseClone()

object.ToString()

object.Equals(object)

object.Equals(object, object)

object.ReferenceEquals(object, object)

object.GetHashCode()

Remarks

None

Constructors

SqliteFeatureSource()

This is the constructor for the class.

public SqliteFeatureSource()

SqliteFeatureSource(SqliteConnection, string)

public SqliteFeatureSource(SqliteConnection connection, string tableName)

Parameters

connection SqliteConnection

tableName string

SqliteFeatureSource(SqliteConnection, string, string, string)

public SqliteFeatureSource(SqliteConnection connection, string tableName, string featureIdColumn, string geometryColumnName)

Parameters

connection SqliteConnection

tableName string

featureIdColumn string

geometryColumnName string

SqliteFeatureSource(string, string)

public SqliteFeatureSource(string connectionString, string tableName)

Parameters

connectionString string

tableName string

SqliteFeatureSource(string, string, string, string)

public SqliteFeatureSource(string connectionString, string tableName, string featureIdColumn, string geometryColumnName)

Parameters

connectionString string

tableName string

featureIdColumn string

geometryColumnName string

Properties

AlternateGeometryIndexTableName

public string AlternateGeometryIndexTableName { get; set; }

Property Value

string

CanExecuteSqlQueryCore

protected override bool CanExecuteSqlQueryCore { get; }

Property Value

bool

CommandTimeout

public int CommandTimeout { get; set; }

Property Value

int

ConnectionString

public string ConnectionString { get; set; }

Property Value

string

DrawnFeatureCount

public int DrawnFeatureCount { get; set; }

Property Value

int

FeatureIdColumn

public string FeatureIdColumn { get; set; }

Property Value

string

FetchTime

public double FetchTime { get; set; }

Property Value

double

GeometryColumnName

public string GeometryColumnName { get; set; }

Property Value

string

IsEditable

public override bool IsEditable { get; }

Property Value

bool

TableName

public string TableName { get; set; }

Property Value

string

TotalBytesDrawn

public int TotalBytesDrawn { get; set; }

Property Value

int

WhereClause

public string WhereClause { get; set; }

Property Value

string

Methods

CanGetBoundingBoxQuicklyCore()

protected override bool CanGetBoundingBoxQuicklyCore()

Returns

bool

CloseCore()

protected override void CloseCore()

CommitTransactionCore(TransactionBuffer)

protected override TransactionResult CommitTransactionCore(TransactionBuffer transactions)

Parameters

transactions TransactionBuffer

Returns

TransactionResult

CreateDatabase(string)

public static void CreateDatabase(string databasePathFilename)

Parameters

databasePathFilename string

CreateSpatialIndex(SqliteConnection, string, string, int)

public static bool CreateSpatialIndex(SqliteConnection SqliteConnection, string tableName, string geometryColumnName, int srid)

Parameters

SqliteConnection SqliteConnection

tableName string

geometryColumnName string

srid int

Returns

bool

CreateTable(SqliteConnection, string, IEnumerable<SqliteColumn>, GeographyUnit)

Creates a new table in the specified Sqlite database.

public static void CreateTable(SqliteConnection connection, string tableName, IEnumerable<SqliteColumn> nonGeometryColumns, GeographyUnit unit)

Parameters

connection SqliteConnection

tableName string

Name of the new table

nonGeometryColumns IEnumerable<SqliteColumn>

nongeometry related columns to include in the new table

unit GeographyUnit

Unit used for projection

CreateTable(string, string, IEnumerable<SqliteColumn>, GeographyUnit)

Creates a new table in the specified Sqlite database.

public static void CreateTable(string connectionString, string tableName, IEnumerable<SqliteColumn> nonGeometryColumns, GeographyUnit unit)

Parameters

connectionString string

Connection string for the database to create the table in

tableName string

Name of the new table

nonGeometryColumns IEnumerable<SqliteColumn>

nongeometry related columns to include in the new table

unit GeographyUnit

Unit used for projection

CreateView(SqliteConnection, string, string, string, GeographyUnit)

public static void CreateView(SqliteConnection connection, string viewName, string createViewSql, string featureIdColumn, GeographyUnit unit)

Parameters

connection SqliteConnection

viewName string

createViewSql string

featureIdColumn string

unit GeographyUnit

CreateView(SqliteConnection, string, string, string, GeographyUnit, string)

Creates a new view in the specified Sqlite database

public static void CreateView(SqliteConnection connection, string viewName, string createViewSql, string featureIdColumn, GeographyUnit unit, string geometryColumnName)

Parameters

connection SqliteConnection

viewName string

Name of the new view

createViewSql string

Sql statement to use when creating the view

featureIdColumn string

The column to use as the feature Id

unit GeographyUnit

Unit used for projection

geometryColumnName string

CreateView(string, string, string, string, GeographyUnit)

Creates a new view in the specified Sqlite database

public static void CreateView(string connectionString, string viewName, string createViewSql, string featureIdColumn, GeographyUnit unit)

Parameters

connectionString string

Connection string for the database to create the table in

viewName string

Name of the new view

createViewSql string

Sql statement to use when creating the view

featureIdColumn string

The column to use as the feature Id

unit GeographyUnit

Unit used for projection

ExecuteNonQueryCore(string)

protected override int ExecuteNonQueryCore(string sqlStatement)

Parameters

sqlStatement string

Returns

int

ExecuteQueryCore(string)

protected override DataTable ExecuteQueryCore(string sqlStatement)

Parameters

sqlStatement string

Returns

DataTable

GetAllFeaturesCore(IEnumerable<string>)

protected override Collection<Feature> GetAllFeaturesCore(IEnumerable<string> columnNames)

Parameters

columnNames IEnumerable<string>

Returns

Collection<Feature>

GetBoundingBoxCore()

protected override RectangleShape GetBoundingBoxCore()

Returns

RectangleShape

GetColumnNames(string, string)

public static Collection<string> GetColumnNames(string connectionString, string tableName)

Parameters

connectionString string

tableName string

Returns

Collection<string>

GetColumnsCore()

protected override Collection<FeatureSourceColumn> GetColumnsCore()

Returns

Collection<FeatureSourceColumn>

GetCountCore()

protected override long GetCountCore()

Returns

long

GetFeatureIdsCore()

protected override Collection<string> GetFeatureIdsCore()

Returns

Collection<string>

GetFeatureIdsInsideBoundingBoxCore(RectangleShape)

protected override Collection<string> GetFeatureIdsInsideBoundingBoxCore(RectangleShape boundingBox)

Parameters

boundingBox RectangleShape

Returns

Collection<string>

GetFeaturesByColumnValueCore(string, string, IEnumerable<string>)

protected override Collection<Feature> GetFeaturesByColumnValueCore(string columnName, string columnValue, IEnumerable<string> returningColumnNames)

Parameters

columnName string

columnValue string

returningColumnNames IEnumerable<string>

Returns

Collection<Feature>

GetFeaturesByIdsCore(IEnumerable<string>, IEnumerable<string>)

protected override Collection<Feature> GetFeaturesByIdsCore(IEnumerable<string> ids, IEnumerable<string> returningColumnNames)

Parameters

ids IEnumerable<string>

returningColumnNames IEnumerable<string>

Returns

Collection<Feature>

GetFeaturesInsideBoundingBoxCore(RectangleShape, IEnumerable<string>)

protected override Collection<Feature> GetFeaturesInsideBoundingBoxCore(RectangleShape boundingBox, IEnumerable<string> returningColumnNames)

Parameters

boundingBox RectangleShape

returningColumnNames IEnumerable<string>

Returns

Collection<Feature>

GetFeaturesOutsideBoundingBoxCore(RectangleShape, IEnumerable<string>)

protected override Collection<Feature> GetFeaturesOutsideBoundingBoxCore(RectangleShape boundingBox, IEnumerable<string> returningColumnNames)

Parameters

boundingBox RectangleShape

returningColumnNames IEnumerable<string>

Returns

Collection<Feature>

GetFirstFeaturesWellKnownTypeCore()

protected override WellKnownType GetFirstFeaturesWellKnownTypeCore()

Returns

WellKnownType

GetTableNames(string)

public static Collection<string> GetTableNames(string connectionString)

Parameters

connectionString string

Returns

Collection<string>

OnExecutingSqlStatement(ExecutingSqlStatementSqliteFeatureSourceEventArgs)

protected virtual void OnExecutingSqlStatement(ExecutingSqlStatementSqliteFeatureSourceEventArgs e)

Parameters

e ExecutingSqlStatementSqliteFeatureSourceEventArgs

OpenCore()

protected override void OpenCore()

Events

ExecutingSqlStatement

public event EventHandler<ExecutingSqlStatementSqliteFeatureSourceEventArgs> ExecutingSqlStatement

Event Type

EventHandler<ExecutingSqlStatementSqliteFeatureSourceEventArgs>