SqliteFeatureSource¶
Namespace: ThinkGeo.Core
This class represents a FeatureSource backed by SQLite.
public class SqliteFeatureSource : FeatureSource
Inheritance Object → FeatureSource → SqliteFeatureSource
Remarks:
None
Properties¶
FetchTime¶
public double FetchTime { get; set; }
Property Value¶
DrawnFeatureCount¶
public int DrawnFeatureCount { get; set; }
Property Value¶
TotalBytesDrawn¶
public int TotalBytesDrawn { get; set; }
Property Value¶
WhereClause¶
public string WhereClause { get; set; }
Property Value¶
CommandTimeout¶
public int CommandTimeout { get; set; }
Property Value¶
GeometryColumnName¶
public string GeometryColumnName { get; set; }
Property Value¶
ConnectionString¶
public string ConnectionString { get; set; }
Property Value¶
TableName¶
public string TableName { get; set; }
Property Value¶
FeatureIdColumn¶
public string FeatureIdColumn { get; set; }
Property Value¶
IsEditable¶
public bool IsEditable { get; }
Property Value¶
AlternateGeometryIndexTableName¶
public string AlternateGeometryIndexTableName { get; set; }
Property Value¶
Id¶
public string Id { get; }
Property Value¶
CanExecuteSqlQuery¶
This property specifies whether the FeatureSource can excute a SQL query or not. If it is false, then it will throw exception when these APIs are calleds: ExecuteScalar, ExecuteNonQuery, ExecuteQuery
public bool CanExecuteSqlQuery { get; }
Property Value¶
Remarks:
The default implementation is false.
IsOpen¶
This property returns true if the FeatureSource is open and false if it is not.
public bool IsOpen { get; }
Property Value¶
Remarks:
Various methods on the FeatureSource require that it be in an open state. If one of those methods is called when the state is not open, then the method will throw an exception. To enter the open state, you must call the FeatureSource's Open method. The method will raise an exception if the current FeatureSource is already open.
Projection¶
public Projection Projection { get; protected set; }
Property Value¶
CanModifyColumnStructure¶
public bool CanModifyColumnStructure { get; }
Property Value¶
IsInTransaction¶
This property returns true if the FeatureSource is in a transaction and false if it is not.
public bool IsInTransaction { get; }
Property Value¶
Remarks:
To enter a transaction, you must first call the BeginTransaction method of the FeatureSource. It is possible that some FeatureSources are read-only and do not allow edits. To end a transaction, you must either call CommitTransaction or RollbackTransaction.
IsTransactionLive¶
This property returns true if the features currently modified in a transaction are expected to reflect their state when calling other methods on the FeatureSource, such as spatial queries.
public bool IsTransactionLive { get; set; }
Property Value¶
Remarks:
The live transaction concept means that all of the modifications you perform during a transaction are live from the standpoint of the querying methods on the object.
As an example, imagine that you have a FeatureSource that has 10 records in it. Next, you begin a transaction and then call GetAllFeatures. The result would be 10 records. After that, you call a delete on one of the records and call the GetAllFeatures again. This time you only get nine records, even though the transaction has not yet been committed. In the same sense, you could have added a new record or modified an existing one and those changes would be considered live, though not committed.
In the case where you modify records -- such as expanding the size of a polygon -- those changes are reflected as well. For example, you expand a polygon by doubling its size and then do a spatial query that would not normally return the smaller record, but instead would return the larger records. In this case, the larger records are returned. You can set this property to be false, as well; in which case, all of the spatially related methods would ignore anything that is currently in the transaction buffer waiting to be committed. In such a case, only after committing the transaction would the FeatureSource reflect the changes.
ProjectionConverter¶
This property holds the projection object that is used within the FeatureSource to ensure that features inside of the FeatureSource are projected.
public ProjectionConverter ProjectionConverter { get; set; }
Property Value¶
Remarks:
By default this property is null, meaning that the data being passed back from any methods on the FeatureSource will be in the coordinate system of the raw data. When you specify a projection object in the property, all incoming and outgoing method calls will subject the features to projection.
For example, if the spatial database you are using has all of its data stored in decimal degrees, but you want to see the data in UTM, you would create a projection object that goes from decimal degrees to UTM and set that as the projection. With this one property set, we will ensure that it will seem to you the developer that all of the data in the FeatureSource is in UTM. That means every spatial query will return UTM projected shapes. You can even pass in UTM shapes for the parameters. Internally, we will ensure that the shapes are converted to and from the projection without any intervention on the developer's part.
In fact, even when you override virtual or abstract core methods in the FeatureSource, you will not need to know about projections at all. Simply work with the data in its native coordinate system. We will handle all of the projection at the high level method.
GeoCache¶
The cache system.
public FeatureCache GeoCache { get; set; }
Property Value¶
Remarks:
You must set IsActive to true for the Cache system. The default is not active.
FeatureIdsToExclude¶
A collection of strings representing record id of features not to get in the Layer.
public Collection<string> FeatureIdsToExclude { get; }
Property Value¶
Remarks:
This string collection is a handy place to specify what records not to get from the source. Suppose you have a shape file of roads and you want to hide the roads within a particular rectangle, simply execute GetFeaturesInsideBoundingBox() and add the id of the return features to the collection and forget about them. Since you can set this by Layer it makes is easy to determine what to and what not to.
TransactionBuffer¶
The TransactionBuffer used in the Transaction System.
public TransactionBuffer TransactionBuffer { get; set; }
Property Value¶
Remarks:
The Transaction System
The transaction system of a FeatureSource sits on top of the inherited implementation of any specific source, such as Oracle Spatial or Shape files. In this way, it functions the same way for every FeatureSource. You start by calling BeginTransaction. This allocates a collection of in-memory change buffers that are used to store changes until you commit the transaction. So, for example, when you call the Add, Delete or Update method, the changes to the feature are stored in memory only. If for any reason you choose to abandon the transaction, you can call RollbackTransaction at any time and the in-memory buffer will be deleted and the changes will be lost. When you are ready to commit the transaction, you call CommitTransaction and the collections of changes are then passed to the CommitTransactionCore method and the implementer of the specific FeatureSource is responsible for integrating your changes into the underlying FeatureSource. By default the IsLiveTransaction property is set to false, which means that until you commit the changes, the FeatureSource API will not reflect any changes that are in the temporary editing buffer.
In the case where the IsLiveTransaction is set to true, then things function slightly differently. The live transaction concept means that all of the modifications you perform during a transaction are live from the standpoint of the querying methods on the object.
As an example, imagine that you have a FeatureSource that has 10 records in it. Next, you begin a transaction and then call GetAllFeatures. The result would be 10 records. After that, you call a delete on one of the records and call the GetAllFeatures again. This time you only get nine records, even though the transaction has not yet been committed. In the same sense, you could have added a new record or modified an existing one and those changes would be considered live, though not committed.
In the case where you modify records -- such as expanding the size of a polygon -- those changes are reflected as well. For example, you expand a polygon by doubling its size and then do a spatial query that would not normally return the smaller record, but instead would return the larger records. In this case, the larger records are returned. You can set this property to be false, as well; in which case, all of the spatially related methods would ignore anything that is currently in the transaction buffer waiting to be committed. In such a case, only after committing the transaction would the FeatureSource reflect the changes.
MaxRecordsToDraw¶
public int MaxRecordsToDraw { get; set; }
Property Value¶
Constructors¶
SqliteFeatureSource()¶
This is the constructor for the class.
public SqliteFeatureSource()
SqliteFeatureSource(String, String, String, String)¶
public SqliteFeatureSource(string connectionString, string tableName, string featureIdColumn, string geometryColumnName)
Parameters¶
connectionString String
tableName String
featureIdColumn String
geometryColumnName 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(SqliteConnection, String)¶
public SqliteFeatureSource(SqliteConnection connection, string tableName)
Parameters¶
connection SqliteConnection
tableName String
SqliteFeatureSource(String, String)¶
public SqliteFeatureSource(string connectionString, string tableName)
Parameters¶
connectionString String
tableName String
Methods¶
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
OnExecutingSqlStatement(ExecutingSqlStatementSqliteFeatureSourceEventArgs)¶
protected void OnExecutingSqlStatement(ExecutingSqlStatementSqliteFeatureSourceEventArgs e)
Parameters¶
e ExecutingSqlStatementSqliteFeatureSourceEventArgs
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(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(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 int ExecuteNonQueryCore(string sqlStatement)
Parameters¶
sqlStatement String
Returns¶
CreateDatabase(String)¶
public static void CreateDatabase(string databasePathFilename)
Parameters¶
databasePathFilename String
GetFirstFeaturesWellKnownTypeCore()¶
protected WellKnownType GetFirstFeaturesWellKnownTypeCore()
Returns¶
OpenCore()¶
protected void OpenCore()
CloseCore()¶
protected void CloseCore()
GetCountCore()¶
protected long GetCountCore()
Returns¶
GetFeaturesInsideBoundingBoxCore(RectangleShape, IEnumerable<String>)¶
protected Collection<Feature> GetFeaturesInsideBoundingBoxCore(RectangleShape boundingBox, IEnumerable<string> returningColumnNames)
Parameters¶
boundingBox RectangleShape
returningColumnNames IEnumerable<String>
Returns¶
GetFeaturesOutsideBoundingBoxCore(RectangleShape, IEnumerable<String>)¶
protected Collection<Feature> GetFeaturesOutsideBoundingBoxCore(RectangleShape boundingBox, IEnumerable<string> returningColumnNames)
Parameters¶
boundingBox RectangleShape
returningColumnNames IEnumerable<String>
Returns¶
CommitTransactionCore(TransactionBuffer)¶
protected TransactionResult CommitTransactionCore(TransactionBuffer transactions)
Parameters¶
transactions TransactionBuffer
Returns¶
GetAllFeaturesCore(IEnumerable<String>)¶
protected Collection<Feature> GetAllFeaturesCore(IEnumerable<string> columnNames)
Parameters¶
columnNames IEnumerable<String>
Returns¶
GetColumnNames(String, String)¶
public static Collection<string> GetColumnNames(string connectionString, string tableName)
Parameters¶
connectionString String
tableName String
Returns¶
GetColumnsCore()¶
protected Collection<FeatureSourceColumn> GetColumnsCore()
Returns¶
Collection<FeatureSourceColumn>
CanGetBoundingBoxQuicklyCore()¶
protected bool CanGetBoundingBoxQuicklyCore()
Returns¶
GetBoundingBoxCore()¶
protected RectangleShape GetBoundingBoxCore()
Returns¶
GetFeaturesByIdsCore(IEnumerable<String>, IEnumerable<String>)¶
protected Collection<Feature> GetFeaturesByIdsCore(IEnumerable<string> ids, IEnumerable<string> returningColumnNames)
Parameters¶
returningColumnNames IEnumerable<String>
Returns¶
GetFeaturesByColumnValueCore(String, String, IEnumerable<String>)¶
protected Collection<Feature> GetFeaturesByColumnValueCore(string columnName, string columnValue, IEnumerable<string> returningColumnNames)
Parameters¶
columnName String
columnValue String
returningColumnNames IEnumerable<String>
Returns¶
ExecuteQueryCore(String)¶
protected DataTable ExecuteQueryCore(string sqlStatement)
Parameters¶
sqlStatement String
Returns¶
DataTable
GetTableNames(String)¶
public static Collection<string> GetTableNames(string connectionString)
Parameters¶
connectionString String
Returns¶
CreateSpatialIndex(SqliteConnection, String, String, Int32)¶
public static bool CreateSpatialIndex(SqliteConnection SqliteConnection, string tableName, string geometryColumnName, int srid)
Parameters¶
SqliteConnection SqliteConnection
tableName String
geometryColumnName String
srid Int32
Returns¶
GetFeatureIdsCore()¶
protected Collection<string> GetFeatureIdsCore()
Returns¶
GetFeatureIdsInsideBoundingBoxCore(RectangleShape)¶
protected Collection<string> GetFeatureIdsInsideBoundingBoxCore(RectangleShape boundingBox)
Parameters¶
boundingBox RectangleShape
Returns¶
Events¶
ExecutingSqlStatement¶
public event EventHandler<ExecutingSqlStatementSqliteFeatureSourceEventArgs> ExecutingSqlStatement;
DrawingProgressChanged¶
public event EventHandler<DrawingProgressChangedEventArgs> DrawingProgressChanged;
GettingColumns¶
public event EventHandler<GettingColumnsFeatureSourceEventArgs> GettingColumns;
GottenColumns¶
public event EventHandler<GottenColumnsFeatureSourceEventArgs> GottenColumns;
GettingFeaturesByIds¶
public event EventHandler<GettingFeaturesByIdsFeatureSourceEventArgs> GettingFeaturesByIds;
GettingFeaturesForDrawing¶
public event EventHandler<GettingFeaturesForDrawingFeatureSourceEventArgs> GettingFeaturesForDrawing;
CustomColumnFetch¶
This event is raised when fields are requested in a feature source method that do not exist in the feature source. It allows you to supplement the data from any outside source you have.
public event EventHandler<CustomColumnFetchEventArgs> CustomColumnFetch;
Remarks:
This event is raised when fields are requested in a feature source method that do not exist in the feature source. It allows you to supplement the data from any outside source you have.
It is used primarily when you have data relating to a particular feature or set of features that is not within source of the data. For example, you may have a shape file of the world whose .dbf component describes the area and population of each country. Additionally, in an outside SQL Server table, you may also have data about the countries, and it is this data that you wish to use for determining how you want to color each country.
To integrate this SQL data, you simply create a file name that does not exist in the .dbf file. Whenever Map Suite is queried to return records that specifically require this field, the FeatureSource will raise this event and allow you the developer to supply the data. In this way, you can query the SQL table and store the data in some sort of collection, and then when the event is raised, simply supply that data.
As this is an event, it will raise for each feature and field combination requested. This means that the event can be raised quite often, and we suggest that you cache the data you wish to supply in memory. We recommend against sending out a new SQL query each time this event is raised. Image that you are supplementing two columns and your query returns 2,000 rows. This means that if you requested those fields, the event would be raised 4,000 times.
CommittingTransaction¶
This event is raised after the CommitTransaction method is called, but before the CommitTransactionCore is called. This allows you access to the TransactionBuffer before the transaction is committed. It also allows you to cancel the pending commit of the transaction.
public event EventHandler<CommittingTransactionEventArgs> CommittingTransaction;
Remarks:
This event is raised before the CommitTransactionCore is called and allows you access to the TransactionBuffer before the transaction is committed. It also allows you to cancel the pending transaction. The TransactionBuffer is the object that stores all of the pending transactions and is accessible through this event to allow you to either add, remove or modify transactions.
In the event that you cancel the CommitTransaction method, the transaction remains intact and you will still be editing. This makes it a nice place to possibly check for connectivity before the TransactionCore code is run, which is where the records are actually committed. Calling the RollBackTransaction method is the only way to permanently cancel a pending transaction without committing it.
CommittedTransaction¶
This event is raised after the CommitTransaction and the CommitTransactionCore are called and allows you access to the TransactionBuffer and the TransactionResults object before CommitTransaction method is returned.
public event EventHandler<CommittedTransactionEventArgs> CommittedTransaction;
Remarks:
This event is raised after the CommitTransactionCore is called and allows you access to the TransactionBuffer and the TransactionResults object before CommitTransaction method is returned.
With this event, you can analyse the results of the transaction and do any cleanup code necessary. In the event some of the records did not commit, you can handle those items here. The TransactionResults object is passed out of the CommitTransaction method so you could analyze it then; however, this is the only place where you have access to both the TransactionResults object and the TransactionBuffer object at the same time. These are useful together to try and determine what went wrong and possibly try and re-commit them.
At the time of this event you will technically be out of the current transaction.
OpeningFeatureSource¶
This event is called before the opening of the FeatureSource.
public event EventHandler<OpeningFeatureSourceEventArgs> OpeningFeatureSource;
Remarks:
This event is called before the opening of the FeatureSource. Technically, this event is called after the calling of the Open method on the FeatureSource, but before the protected OpenCore method.
It is typical that the FeatureSource may be opened and closed may times during the life cycle of your application. The type of control the MapEngine is embedded in will dictate how often this happens. For example, in the case of the Web Edition, each time a FeatureSource is in the Ajax or Post Back part of the page cycle, it will close the FeatureSource before returning back to the client. This is to conserve resources, as the web is a connection-less environment. In the case of the Desktop Edition, we can keep the FeaureSources open, knowing that we can maintain a persistent connection.
OpenedFeatureSource¶
This event is called after the opening of the FeatureSource.
public event EventHandler<OpenedFeatureSourceEventArgs> OpenedFeatureSource;
Remarks:
This event is called after the opening of the FeatureSource. Technically, this event is called after the calling of the Open method on the FeatureSource and after the protected OpenCore method is called.
It is typical that the FeatureSource may be opened and closed may times during the life cycle of your application. The type of control the MapEngine is embedded in will dictate how often this happens. For example, in the case of the Web Edition, each time a FeatureSource is in the Ajax or Post Back part of the page cycle, it will close the FeatureSource before returning back to the client. This is to conserve resources, as the web is a connection-less environment. In the case of the Desktop Edition, we can keep the FeaureSources open, knowing that we can maintain a persistent connection.
ClosingFeatureSource¶
This event is called before the closing of the FeatureSource.
public event EventHandler<ClosingFeatureSourceEventArgs> ClosingFeatureSource;
Remarks:
This event is called before the closing of the FeatureSource. Technically, this event is called after the calling of the Close method on the FeatureSource, but before the protected CloseCore method.
It is typical that the FeatureSource may be opened and closed may times during the life cycle of your application. The type of control the MapEngine is embedded in will dictate how often this happens. For example, in the case of the Web Edition, each time a FeatureSource is in the Ajax or Post Back part of the page cycle, it will close the FeatureSource before returning back to the client. This is to conserve resources, as the web is a connection-less environment. In the case of the Desktop Edition, we can keep the FeaureSources open, knowing that we can maintain a persistent connection.
ClosedFeatureSource¶
This event is called after the closing of the FeatureSource.
public event EventHandler<ClosedFeatureSourceEventArgs> ClosedFeatureSource;
Remarks:
This event is called after the closing of the FeatureSource. Technically, this event is called after the calling of the Close method on the FeatureSource and after the protected CloseCore method.
It is typical that the FeatureSource may be opened and closed may times during the life cycle of your application. The type of control the MapEngine is embedded in will dictate how often this happens. For example, in the case of the Web Edition, each time a FeatureSource is in the Ajax or Post Back part of the page cycle, it will close the FeatureSource before returning back to the client. This is to conserve resources, as the web is a connection-less environment. In the case of the Desktop Edition, we can keep the FeaureSources open, knowing that we can maintain a persistent connection.