This class represents a layer backed by Microsoft SQL 2008.

• System.Object
  • ThinkGeo.MapSuite.Core.Layer
    • ThinkGeo.MapSuite.Core.FeatureLayer
      • ThinkGeo.MapSuite.Core.MsSql2008FeatureLayer

MsSql2008FeatureLayer()

• This is the constructor for the class.

• N/A

MsSql2008FeatureLayer(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.

MsSql2008FeatureLayer(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

MsSql2008FeatureLayer(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.

MsSql2008FeatureLayer(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

MsSql2008FeatureLayer(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

MsSql2008FeatureLayer(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()

• Check if all geometry are valid for spatial query.

• N/A

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

BuildIndex(BuildIndexMode)

• Build Spatial index

• N/A

• Type:Void
• Description:N/A

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

MakeAllGeometriesValid()

• To make the geometry type data valid, and update the table.

• 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()

• Get The shape type from the first record.

• N/A

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

ExecuteNonQuery(String)

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

• 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.

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

GetThreadSafetyLevel()

• N/A

• N/A

• Type:ThreadSafetyLevel
• Description:N/A

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

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

GetType()

• N/A

• N/A

• Type:Type
• Description:N/A

CreateTable(String,String,SpatialDataType)

• This method creates a Sql Spatial Data table in MsSql2008 server.

• 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:SpatialDataType
  • Description:Represents the Spatial Data Type for the Spatial Data column

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

• This method creates a Sql Spatial Data table in MsSql2008 server.

• 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:SpatialDataType
  • 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,SpatialDataType,IEnumerable<FeatureSourceColumn>,OverwriteMode)

• This method creates a Sql Spatial Data table in MsSql2008 server.

• 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:SpatialDataType
  • 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

RequireLinkProcess(IEnumerable<String>)

• N/A

• N/A

• Type:Boolean
• Description:N/A

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

DrawFeaturesWithStyleFilters(GeoCanvas,Dictionary<String,Collection<Feature»,Collection<SimpleCandidate>,ZoomLevel,RectangleShape)

• N/A

• N/A

• Type:Void
• Description:N/A

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

• featuresForFilters
  • Type:Dictionary<String,Collection<Feature»
  • Description:N/A

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

• currentZoomLevel
  • Type:ZoomLevel
  • Description:N/A

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

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

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

GetThreadSafetyLevelCore()

• N/A

• N/A

• Type:ThreadSafetyLevel
• 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

Finalize()

• N/A

• N/A

• Type:Void
• Description:N/A

MemberwiseClone()

• N/A

• N/A

• Type:Object
• Description:N/A

CommandTimeout

This property gets and sets the amount of time that can elapse before the command will timeout and abort.

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

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

None

• Type:String

TableName

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

None

• Type:String

WhereClause

N/A

N/A

• Type: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 MsSql2008FeatureLayer, we override this API and mark it as true.

The default implementation in the base class returns false.

• Type:Boolean

Srid

Specify what kind srid data to be used.

N/A

• Type:Int32

SchemaName

N/A

N/A

• Type:String

SpatialIndexName

N/A

N/A

• Type:String

FeatureIdColumn

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

None

• Type:String

CustomGeometryColumnName

N/A

N/A

• Type:String

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

DrawingMarginPercentage

N/A

N/A

• Type:Double

DrawingMarginInPixel

N/A

N/A

• Type:Single

GeometryValidationMode

N/A

N/A

• Type:GeometryValidationMode

RequestDrawingInterval

N/A

N/A

• Type:TimeSpan

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

DrawingExceptionMode

N/A

N/A

• Type:DrawingExceptionMode

FetchedCount

N/A

N/A

• Type:Int64

FetchedBytes

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

RequestedDrawing N/A

N/A

Event Arguments:RequestedDrawingLayerEventArgs

RequestingDrawing N/A

N/A

Event Arguments:RequestingDrawingLayerEventArgs

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