ThinkGeo.Core.SqlServerFeatureLayer

• System.Object
  • ThinkGeo.Core.Layer
    • ThinkGeo.Core.FeatureLayer
      • ThinkGeo.Core.SqlServerFeatureLayer

SqlServerFeatureLayer()

• This is the constructor for the class.

• N/A

SqlServerFeatureLayer(String,String,String)

• This is the constructor for the class.

• None

• connectionString
  • Type:String
  • Description:This parameter represents the connection string that will be used to connect to the server.

• tableName
  • Type:String
  • Description:This parameter represents the table name being accessed.

• featureIdColumn
  • Type:String
  • Description:This parameter represents the name of the column that holds the unique feature Id.

SqlServerFeatureLayer(String,String,String,DatabaseConnectionMode)

• N/A

• N/A

• connectionString
  • Type:String
  • Description:N/A

• tableName
  • Type:String
  • Description:N/A

• featureIdColumn
  • Type:String
  • Description:N/A

• databaseConnectionMode
  • Type:DatabaseConnectionMode
  • Description:N/A

SqlServerFeatureLayer(String,String,String,Int32)

• This is the constructor for the class.

• None

• connectionString
  • Type:String
  • Description:This parameter represents the connection string that will be used to connect to the server.

• tableName
  • Type:String
  • Description:This parameter represents the table name being accessed.

• featureIdColumn
  • Type:String
  • Description:This parameter represents the name of the column that holds the unique feature Id.

• srid
  • Type:Int32
  • Description:Specify what kind srid data to be used.

SqlServerFeatureLayer(String,String,String,Int32,String)

• N/A

• N/A

• connectionString
  • Type:String
  • Description:N/A

• tableName
  • Type:String
  • Description:N/A

• featureIdColumn
  • Type:String
  • Description:N/A

• srid
  • Type:Int32
  • Description:N/A

• schemaName
  • Type:String
  • Description:N/A

SqlServerFeatureLayer(String,String,String,Int32,DatabaseConnectionMode)

• N/A

• N/A

• connectionString
  • Type:String
  • Description:N/A

• tableName
  • Type:String
  • Description:N/A

• featureIdColumn
  • Type:String
  • Description:N/A

• srid
  • Type:Int32
  • Description:N/A

• databaseConnectionMode
  • Type:DatabaseConnectionMode
  • Description:N/A

SqlServerFeatureLayer(String,String,String,Int32,String,DatabaseConnectionMode)

• N/A

• N/A

• connectionString
  • Type:String
  • Description:N/A

• tableName
  • Type:String
  • Description:N/A

• featureIdColumn
  • Type:String
  • Description:N/A

• srid
  • Type:Int32
  • Description:N/A

• schemaName
  • Type:String
  • Description:N/A

• databaseConnectionMode
  • Type:DatabaseConnectionMode
  • Description:N/A

Validate()

• N/A

• N/A

• Type:Dictionary<String,String>
• Description:If all geometry are valid, the count of the returning dictionary is 0.

BuildIndex(BuildIndexMode)

• N/A

• N/A

• Type:Void
• Description:N/A

• buildIndexMode
  • Type:BuildIndexMode
  • Description:Build Index Mode

MakeAllGeometriesValid()

• N/A

• This function will check whether the geometry is valid for spatial query, if it is not, then the function will make it valid and save it back to the table. For example: Here's a invalid LineString LINESTRING(0 2,1 1,1 0,1 1,2 2)) which is overlaps itself, it's invalid. After use this function, it will be MULTILINESTRING¹⁾

• Type:Void
• Description:N/A

GetFirstGeometryType()

• N/A

• N/A

• Type:WellKnownType
• Description:The shape type of the first record.

ExecuteNonQuery(String)

• N/A

• This methods executes a query that has no results.

• Type:Int32
• Description:None

• sqlStatement
  • Type:String
  • Description:This parameter represents the SQL statement that will be executed.

CloneDeep()

• N/A

• N/A

• Type:Layer
• Description:N/A

Open()

• N/A

• N/A

• Type:Void
• Description:N/A

Close()

• N/A

• N/A

• Type:Void
• Description:N/A

GetBoundingBox()

• N/A

• N/A

• Type:RectangleShape
• Description:N/A

Draw(GeoCanvas,Collection<SimpleCandidate>)

• N/A

• N/A

• Type:Void
• Description:N/A

• canvas
  • Type:GeoCanvas
  • Description:N/A

• labelsInAllLayers
  • Type:Collection<SimpleCandidate>
  • Description:N/A

RequestDrawing()

• N/A

• N/A

• Type:Void
• Description:N/A

RequestDrawing(RectangleShape)

• N/A

• N/A

• Type:Void
• Description:N/A

• extentToRefresh
  • Type:RectangleShape
  • Description:N/A

RequestDrawing(IEnumerable<RectangleShape>)

• N/A

• N/A

• Type:Void
• Description:N/A

• extentsToRefresh
  • Type:IEnumerable<RectangleShape>
  • Description:N/A

RequestDrawing(TimeSpan)

• N/A

• N/A

• Type:Void
• Description:N/A

• bufferTime
  • Type:TimeSpan
  • Description:N/A

RequestDrawing(TimeSpan,RequestDrawingBufferTimeType)

• N/A

• N/A

• Type:Void
• Description:N/A

• bufferTime
  • Type:TimeSpan
  • Description:N/A

• bufferTimeType
  • Type:RequestDrawingBufferTimeType
  • Description:N/A

RequestDrawing(RectangleShape,TimeSpan)

• N/A

• N/A

• Type:Void
• Description:N/A

• extentToRefresh
  • Type:RectangleShape
  • Description:N/A

• bufferTime
  • Type:TimeSpan
  • Description:N/A

RequestDrawing(RectangleShape,TimeSpan,RequestDrawingBufferTimeType)

• N/A

• N/A

• Type:Void
• Description:N/A

• extentToRefresh
  • Type:RectangleShape
  • Description:N/A

• bufferTime
  • Type:TimeSpan
  • Description:N/A

• bufferTimeType
  • Type:RequestDrawingBufferTimeType
  • Description:N/A

RequestDrawing(IEnumerable<RectangleShape>,TimeSpan)

• N/A

• N/A

• Type:Void
• Description:N/A

• extentsToRefresh
  • Type:IEnumerable<RectangleShape>
  • Description:N/A

• bufferTime
  • Type:TimeSpan
  • Description:N/A

RequestDrawing(IEnumerable<RectangleShape>,TimeSpan,RequestDrawingBufferTimeType)

• N/A

• N/A

• Type:Void
• Description:N/A

• extentsToRefresh
  • Type:IEnumerable<RectangleShape>
  • Description:N/A

• bufferTime
  • Type:TimeSpan
  • Description:N/A

• bufferTimeType
  • Type:RequestDrawingBufferTimeType
  • Description:N/A

GetType()

• N/A

• N/A

• Type:Type
• Description:N/A

ToString()

• N/A

• N/A

• Type:String
• Description:N/A

Equals(Object)

• N/A

• N/A

• Type:Boolean
• Description:N/A

• obj
  • Type:Object
  • Description:N/A

GetHashCode()

• N/A

• N/A

• Type:Int32
• Description:N/A

CreateTable(String,String,MsSqlSpatialDataType)

• N/A

• N/A

• Type:Void
• Description:N/A

• connectionString
  • Type:String
  • Description:Represents the connection string to the database

• tableName
  • Type:String
  • Description:Represents the name for the table

• spatialDataType
  • Type:MsSqlSpatialDataType
  • Description:Represents the Spatial Data Type for the Spatial Data column

CreateTable(String,String,MsSqlSpatialDataType,IEnumerable<FeatureSourceColumn>)

• N/A

• N/A

• Type:Void
• Description:N/A

• connectionString
  • Type:String
  • Description:Represents the connection string to the database

• tableName
  • Type:String
  • Description:Represents the name for the table

• spatialDataType
  • Type:MsSqlSpatialDataType
  • Description:Represents the Spatial Data Type for the Spatial Data column

• columns
  • Type:IEnumerable<FeatureSourceColumn>
  • Description:Represnts information for creating columns besides Spatial Data Column

CreateTable(String,String,MsSqlSpatialDataType,IEnumerable<FeatureSourceColumn>,OverwriteMode)

• N/A

• N/A

• Type:Void
• Description:N/A

• connectionString
  • Type:String
  • Description:Represents the connection string to the database

• tableName
  • Type:String
  • Description:Represents the name for the table

• spatialDataType
  • Type:MsSqlSpatialDataType
  • Description:Represents the Spatial Data Type for the Spatial Data column

• columns
  • Type:IEnumerable<FeatureSourceColumn>
  • Description:Represnts information for creating columns besides Spatial Data Column

• overwriteMode
  • Type:OverwriteMode
  • Description:Indicates whether need to overwrite the datatable if there's already an exsited one

OnDrawingFeatures(DrawingFeaturesEventArgs)

• N/A

• N/A

• Type:Void
• Description:N/A

• e
  • Type:DrawingFeaturesEventArgs
  • Description:N/A

OnDrawingWrappingFeatures(DrawingWrappingFeaturesFeatureLayerEventArgs)

• N/A

• N/A

• Type:Void
• Description:N/A

• e
  • Type:DrawingWrappingFeaturesFeatureLayerEventArgs
  • Description:N/A

DrawCore(GeoCanvas,Collection<SimpleCandidate>)

• N/A

• N/A

• Type:Void
• Description:N/A

• canvas
  • Type:GeoCanvas
  • Description:N/A

• labelsInAllLayers
  • Type:Collection<SimpleCandidate>
  • Description:N/A

SetupTools()

• N/A

• N/A

• Type:Void
• Description:N/A

SetupToolsCore()

• N/A

• N/A

• Type:Void
• Description:N/A

OpenCore()

• N/A

• N/A

• Type:Void
• Description:N/A

CloseCore()

• N/A

• N/A

• Type:Void
• Description:N/A

GetBoundingBoxCore()

• N/A

• N/A

• Type:RectangleShape
• Description:N/A

GetWrappingFeaturesForDrawing(WrappingWorldDirection,RectangleShape,Double,Double,IEnumerable<String>,RectangleShape)

• N/A

• N/A

• Type:Collection<Feature>
• Description:N/A

• wrappingFeatureDirection
  • Type:WrappingWorldDirection
  • Description:N/A

• drawingWorldExtent
  • Type:RectangleShape
  • Description:N/A

• canvasWidth
  • Type:Double
  • Description:N/A

• canvasHeight
  • Type:Double
  • Description:N/A

• returningColumnNames
  • Type:IEnumerable<String>
  • Description:N/A

• wrappingWorldExtent
  • Type:RectangleShape
  • Description:N/A

CloneDeepCore()

• N/A

• N/A

• Type:Layer
• Description:N/A

DrawException(GeoCanvas,Exception)

• N/A

• N/A

• Type:Void
• Description:N/A

• canvas
  • Type:GeoCanvas
  • Description:N/A

• e
  • Type:Exception
  • Description:N/A

DrawExceptionCore(GeoCanvas,Exception)

• N/A

• N/A

• Type:Void
• Description:N/A

• canvas
  • Type:GeoCanvas
  • Description:N/A

• e
  • Type:Exception
  • Description:N/A

OnDrawingException(DrawingExceptionLayerEventArgs)

• N/A

• N/A

• Type:Void
• Description:N/A

• e
  • Type:DrawingExceptionLayerEventArgs
  • Description:N/A

OnDrawnException(DrawnExceptionLayerEventArgs)

• N/A

• N/A

• Type:Void
• Description:N/A

• e
  • Type:DrawnExceptionLayerEventArgs
  • Description:N/A

DrawAttributionCore(GeoCanvas,String)

• N/A

• N/A

• Type:Void
• Description:N/A

• canvas
  • Type:GeoCanvas
  • Description:N/A

• attribution
  • Type:String
  • Description:N/A

OnDrawingAttribution(DrawingAttributionLayerEventArgs)

• N/A

• N/A

• Type:Void
• Description:N/A

• args
  • Type:DrawingAttributionLayerEventArgs
  • Description:N/A

OnDrawnAttribution(DrawnAttributionLayerEventArgs)

• N/A

• N/A

• Type:Void
• Description:N/A

• args
  • Type:DrawnAttributionLayerEventArgs
  • Description:N/A

OnDrawingProgressChanged(DrawingProgressChangedEventArgs)

• N/A

• N/A

• Type:Void
• Description:N/A

• e
  • Type:DrawingProgressChangedEventArgs
  • Description:N/A

OnRequestedDrawing(RequestedDrawingLayerEventArgs)

• N/A

• N/A

• Type:Void
• Description:N/A

• eventArgs
  • Type:RequestedDrawingLayerEventArgs
  • Description:N/A

OnRequestingDrawing(RequestingDrawingLayerEventArgs)

• N/A

• N/A

• Type:Void
• Description:N/A

• eventArgs
  • Type:RequestingDrawingLayerEventArgs
  • Description:N/A

MemberwiseClone()

• N/A

• N/A

• Type:Object
• Description:N/A

Finalize()

• N/A

• N/A

• Type:Void
• Description:N/A

CommandTimeout

• N/A

• You can use this to set a time limit for the query before it times out.

• Type:Int32

DatabaseConnectionMode

• N/A

• N/A

• Type:DatabaseConnectionMode

ConnectionString

• N/A

• None

• Type:String

TableName

• N/A

• None

• Type:String

WhereClause

• N/A

• N/A

• Type:String

HasBoundingBox

• N/A

• The default implementation in the base class returns false.

• Type:Boolean

Srid

• N/A

• N/A

• Type:Int32

SchemaName

• N/A

• N/A

• Type:String

SpatialIndexName

• N/A

• N/A

• Type:String

FeatureIdColumn

• N/A

• None

• Type:String

CustomGeometryColumnName

• N/A

• N/A

• Type:String

Projection

• N/A

• N/A

• Type:Projection

WrappingExtent

• N/A

• N/A

• Type:RectangleShape

WrappingMode

• N/A

• N/A

• Type:WrappingMode

EditTools

• N/A

• N/A

• Type:EditTools

FeatureIdsToExclude

• N/A

• N/A

• Type:Collection<String>

QueryTools

• N/A

• N/A

• Type:QueryTools

MaxRecordsToDraw

• N/A

• N/A

• Type:Int32

FeatureSource

• N/A

• N/A

• Type:FeatureSource

DrawingQuality

• N/A

• N/A

• Type:DrawingQuality

ZoomLevelSet

• N/A

• N/A

• Type:ZoomLevelSet

DrawingMarginInPixel

• N/A

• N/A

• Type:Single

IsOpen

• N/A

• N/A

• Type:Boolean

DrawingTime

• N/A

• N/A

• Type:TimeSpan

Name

• N/A

• N/A

• Type:String

Attribution

• N/A

• N/A

• Type:String

IsVisible

• N/A

• N/A

• Type:Boolean

Transparency

• N/A

• N/A

• Type:Single

BlueTranslation

• N/A

• N/A

• Type:Single

RedTranslation

• N/A

• N/A

• Type:Single

GreenTranslation

• N/A

• N/A

• Type:Single

KeyColors

• N/A

• N/A

• Type:Collection<GeoColor>

IsNegative

• N/A

• N/A

• Type:Boolean

IsGrayscale

• N/A

• N/A

• Type:Boolean

ColorMappings

• N/A

• N/A

• Type:Dictionary<GeoColor,GeoColor>

DrawingExceptionMode

• N/A

• N/A

• Type:DrawingExceptionMode

ThreadSafe

• N/A

• N/A

• Type:ThreadSafetyLevel

RequestDrawingInterval

• N/A

• N/A

• Type:TimeSpan

FetchedCount

• N/A

• N/A

• Type:Int64

StyleTime

• N/A

• N/A

• Type:TimeSpan

FetchTime

• N/A

• N/A

• Type:TimeSpan

IsOpenCore

• N/A

• N/A

• Type:Boolean

DrawingFeatures

• N/A

• N/A

Event Arguments:DrawingFeaturesEventArgs

DrawingWrappingFeatures

• N/A

• N/A

Event Arguments:DrawingWrappingFeaturesFeatureLayerEventArgs

DrawingProgressChanged

• N/A

• N/A

Event Arguments:DrawingProgressChangedEventArgs

DrawingException

• N/A

• N/A

Event Arguments:DrawingExceptionLayerEventArgs

DrawnException

• N/A

• N/A

Event Arguments:DrawnExceptionLayerEventArgs

DrawingAttribution

• N/A

• N/A

Event Arguments:DrawingAttributionLayerEventArgs

DrawnAttribution

• N/A

• N/A

Event Arguments:DrawnAttributionLayerEventArgs

RequestedDrawing

• N/A

• N/A

Event Arguments:RequestedDrawingLayerEventArgs

RequestingDrawing

• N/A

• N/A

Event Arguments:RequestingDrawingLayerEventArgs