Class SqliteFeatureLayer

Namespace

ThinkGeo.Core

Assembly

ThinkGeo.Core.dll

This class represents a FeatureSource backed by SQLite.

public class SqliteFeatureLayer : FeatureLayer

Inheritance

object

Layer

FeatureLayer

SqliteFeatureLayer

Inherited Members

FeatureLayer.OnDrawingFeatures(DrawingFeaturesEventArgs)

FeatureLayer.OnDrawingWrappingFeatures(DrawingWrappingFeaturesFeatureLayerEventArgs)

FeatureLayer.DrawCore(GeoCanvas, Collection<SimpleCandidate>)

FeatureLayer.IsDrawingNeededCore(double)

FeatureLayer.SetupTools()

FeatureLayer.SetupToolsCore()

FeatureLayer.OpenCore()

FeatureLayer.CloseCore()

FeatureLayer.GetBoundingBoxCore()

FeatureLayer.GetWrappingFeaturesForDrawing(RectangleShape, IEnumerable<string>, RectangleShape)

FeatureLayer.GetCeiling(double)

FeatureLayer.Projection

FeatureLayer.EditTools

FeatureLayer.FeatureIdsToExclude

FeatureLayer.QueryTools

FeatureLayer.MaxRecordsToDraw

FeatureLayer.FeatureSource

FeatureLayer.DrawingQuality

FeatureLayer.ZoomLevelSet

FeatureLayer.DrawingMarginInPixel

FeatureLayer.IsOpenCore

FeatureLayer.DrawingFeatures

FeatureLayer.DrawingWrappingFeatures

Layer.CloneDeep()

Layer.CloneDeepCore()

Layer.LoadLayer(Uri)

Layer.LoadLayer(Stream)

Layer.Open()

Layer.Close()

Layer.GetBoundingBox()

Layer.Draw(GeoCanvas, Collection<SimpleCandidate>)

Layer.DrawWithColorTransformation(GeoCanvas, Collection<SimpleCandidate>, RectangleShape, float, float)

Layer.DrawException(GeoCanvas, Exception)

Layer.DrawExceptionCore(GeoCanvas, Exception)

Layer.OnDrawingException(DrawingExceptionLayerEventArgs)

Layer.OnDrawnException(DrawnExceptionLayerEventArgs)

Layer.IsDrawingNeeded(double)

Layer.DrawAttributionCore(GeoCanvas, string)

Layer.OnDrawingAttribution(DrawingAttributionLayerEventArgs)

Layer.OnDrawnAttribution(DrawnAttributionLayerEventArgs)

Layer.OnDrawingProgressChanged(DrawingProgressChangedEventArgs)

Layer.RequestDrawing()

Layer.RequestDrawing(RectangleShape)

Layer.RequestDrawing(IEnumerable<RectangleShape>)

Layer.RequestDrawing(TimeSpan)

Layer.RequestDrawing(TimeSpan, RequestDrawingBufferTimeType)

Layer.RequestDrawing(RectangleShape, TimeSpan)

Layer.RequestDrawing(RectangleShape, TimeSpan, RequestDrawingBufferTimeType)

Layer.RequestDrawing(IEnumerable<RectangleShape>, TimeSpan)

Layer.RequestDrawing(IEnumerable<RectangleShape>, TimeSpan, RequestDrawingBufferTimeType)

Layer.StartRequestDrawing()

Layer.OnRequestedDrawing(RequestedDrawingLayerEventArgs)

Layer.OnRequestingDrawing(RequestingDrawingLayerEventArgs)

Layer.IsOpen

Layer.DrawingTime

Layer.Name

Layer.Attribution

Layer.IsVisible

Layer.Transparency

Layer.BlueTranslation

Layer.RedTranslation

Layer.GreenTranslation

Layer.KeyColors

Layer.IsNegative

Layer.IsGrayscale

Layer.ColorMappings

Layer.DrawingExceptionMode

Layer.ThreadSafe

Layer.Background

Layer.WrappingMode

Layer.WrappingExtent

Layer.RequestDrawingInterval

Layer.DrawingProgressChanged

Layer.DrawingException

Layer.DrawnException

Layer.DrawingAttribution

Layer.DrawnAttribution

Layer.RequestedDrawing

Layer.RequestingDrawing

object.GetType()

object.MemberwiseClone()

object.ToString()

object.Equals(object)

object.Equals(object, object)

object.ReferenceEquals(object, object)

object.GetHashCode()

Remarks

None

Constructors

SqliteFeatureLayer()

This is the constructor for the class.

public SqliteFeatureLayer()

SqliteFeatureLayer(SqliteConnection, string, string, string)

public SqliteFeatureLayer(SqliteConnection connection, string tableName, string featureIdeColumn, string geometryColumnName)

Parameters

connection SqliteConnection

tableName string

featureIdeColumn string

geometryColumnName string

SqliteFeatureLayer(string, string, string, string)

This is the constructor for the class.

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

Parameters

connectionString string

This parameter represents the connection string to connect to the server.

tableName string

This parameter represents the table name being accessed.

featureIdColumn string

This parameter represents the name of the column that holds the unique feature Id.

geometryColumnName string

Remarks

None

Properties

CommandTimeout

public int CommandTimeout { get; set; }

Property Value

int

ConnectionString

This property gets and sets the connection string used to connect to the server.

public string ConnectionString { get; set; }

Property Value

string

This property gets the connection string used to connect to the server.

Remarks

None

FeatureIdColumn

This property gets or sets the name of the column that holds the unique feature Id.

public string FeatureIdColumn { get; set; }

Property Value

string

This property gets the name of the column that holds the unique feature Id.

Remarks

None

GeometryColumnName

public string GeometryColumnName { get; set; }

Property Value

string

HasBoundingBox

This property checks to see if a Layer has a BoundingBox or not. If it has no BoundingBox, it will throw an exception when you call the GetBoundingBox() and GetFullExtent() APIs. In SqliteFeatureLayer, we override this API and mark it as true.

public override bool HasBoundingBox { get; }

Property Value

bool

Remarks

The default implementation in the base class returns false.

TableName

This property gets or sets the table name the database will use.

public string TableName { get; set; }

Property Value

string

This property gets the table name the database will use.

Remarks

None

WhereClause

public string WhereClause { get; set; }

Property Value

string

Methods

ExecuteNonQuery(string)

This method executes a query that does not return a SQL result.

public int ExecuteNonQuery(string sqlStatement)

Parameters

sqlStatement string

This parameter represents the SQL statement that will be executed.

Returns

int

The number of records effected.

Remarks

This methods executes a query that has no results.

GetFirstGeometryType()

public WellKnownType GetFirstGeometryType()

Returns

WellKnownType