User Tools

Site Tools


thinkgeo.mapsuite.portablecore.mssql2008featurelayer

ThinkGeo.MapSuite.Core.MsSql2008FeatureLayer

Note: The page was created before Map Suite 10. Map Suite 10.0 organized many classes into new namespaces and assemblies as well as had a few minor breaks in compatibility. The majority of previously built code should work without modification assuming the new namespaces are added. For guidance on upgrading your existing code, please check out MapSuite 10 Upgrade Guide.

This class represents a layer backed by Microsoft SQL 2008.

Inheritance Hierarchy

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

Members Summary

Public Constructors

MsSql2008FeatureLayer()

This is the constructor for the class.

Remarks

N/A

Parameters

MsSql2008FeatureLayer(String,String,String)

This is the constructor for the class.

Remarks

None

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

Remarks

N/A

Parameters
  • connectionString
    • Type:String
    • Description:N/A
  • tableName
    • Type:String
    • Description:N/A
  • featureIdColumn
    • Type:String
    • Description:N/A

MsSql2008FeatureLayer(String,String,String,Int32)

This is the constructor for the class.

Remarks

None

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

Remarks

N/A

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

Remarks

N/A

Parameters
  • connectionString
    • Type:String
    • Description:N/A
  • tableName
    • Type:String
    • Description:N/A
  • featureIdColumn
    • Type:String
    • Description:N/A
  • srid
    • Type:Int32
    • Description:N/A

MsSql2008FeatureLayer(String,String,String,Int32,String,DatabaseConnectionMode)

N/A

Remarks

N/A

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

Protected Constructors

Public Methods

Validate()

Check if all geometry are valid for spatial query.

Remarks

N/A

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

BuildIndex(BuildIndexMode)

Build Spatial index

Remarks

N/A

Return Value
  • Type:Void
  • Description:N/A
Parameters

MakeAllGeometriesValid()

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

Remarks

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 MULTILINESTRING1)

Return Value
  • Type:Void
  • Description:N/A
Parameters

GetFirstGeometryType()

Get The shape type from the first record.

Remarks

N/A

Return Value
  • Description:The shape type of the first record.
Parameters

ExecuteNonQuery(String)

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

Remarks

This methods executes a query that has no results.

Return Value
  • Type:Int32
  • Description:None
Parameters
  • sqlStatement
    • Type:String
    • Description:This parameter represents the SQL statement that will be executed.

RequestDrawing()

N/A

Remarks

N/A

Return Value
  • Type:Void
  • Description:N/A
Parameters

RequestDrawing(RectangleShape)

N/A

Remarks

N/A

Return Value
  • Type:Void
  • Description:N/A
Parameters

RequestDrawing(IEnumerable<RectangleShape>)

N/A

Remarks

N/A

Return Value
  • Type:Void
  • Description:N/A
Parameters

RequestDrawing(TimeSpan)

N/A

Remarks

N/A

Return Value
  • Type:Void
  • Description:N/A
Parameters
  • bufferTime
    • Type:TimeSpan
    • Description:N/A

RequestDrawing(TimeSpan,RequestDrawingBufferTimeType)

N/A

Remarks

N/A

Return Value
  • Type:Void
  • Description:N/A
Parameters
  • bufferTime
    • Type:TimeSpan
    • Description:N/A

RequestDrawing(RectangleShape,TimeSpan)

N/A

Remarks

N/A

Return Value
  • Type:Void
  • Description:N/A
Parameters
  • bufferTime
    • Type:TimeSpan
    • Description:N/A

RequestDrawing(RectangleShape,TimeSpan,RequestDrawingBufferTimeType)

N/A

Remarks

N/A

Return Value
  • Type:Void
  • Description:N/A
Parameters
  • bufferTime
    • Type:TimeSpan
    • Description:N/A

RequestDrawing(IEnumerable<RectangleShape>,TimeSpan)

N/A

Remarks

N/A

Return Value
  • Type:Void
  • Description:N/A
Parameters
  • bufferTime
    • Type:TimeSpan
    • Description:N/A

RequestDrawing(IEnumerable<RectangleShape>,TimeSpan,RequestDrawingBufferTimeType)

N/A

Remarks

N/A

Return Value
  • Type:Void
  • Description:N/A
Parameters
  • bufferTime
    • Type:TimeSpan
    • Description:N/A

GetThreadSafetyLevel()

N/A

Remarks

N/A

Return Value
Parameters

CloneDeep()

N/A

Remarks

N/A

Return Value
  • Type:Layer
  • Description:N/A
Parameters

Open()

N/A

Remarks

N/A

Return Value
  • Type:Void
  • Description:N/A
Parameters

Close()

N/A

Remarks

N/A

Return Value
  • Type:Void
  • Description:N/A
Parameters

GetBoundingBox()

N/A

Remarks

N/A

Return Value
Parameters

Draw(GeoCanvas,Collection<SimpleCandidate>)

N/A

Remarks

N/A

Return Value
  • Type:Void
  • Description:N/A
Parameters

ToString()

N/A

Remarks

N/A

Return Value
  • Type:String
  • Description:N/A
Parameters

Equals(Object)

N/A

Remarks

N/A

Return Value
  • Type:Boolean
  • Description:N/A
Parameters
  • obj
    • Type:Object
    • Description:N/A

GetHashCode()

N/A

Remarks

N/A

Return Value
  • Type:Int32
  • Description:N/A
Parameters

GetType()

N/A

Remarks

N/A

Return Value
  • Type:Type
  • Description:N/A
Parameters

CreateTable(String,String,SpatialDataType)

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

Remarks

N/A

Return Value
  • Type:Void
  • Description:N/A
Parameters
  • connectionString
    • Type:String
    • Description:Represents the connection string to the database
  • tableName
    • Type:String
    • Description:Represents the name for the table
  • 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.

Remarks

N/A

Return Value
  • Type:Void
  • Description:N/A
Parameters
  • connectionString
    • Type:String
    • Description:Represents the connection string to the database
  • tableName
    • Type:String
    • Description:Represents the name for the table
  • 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.

Remarks

N/A

Return Value
  • Type:Void
  • Description:N/A
Parameters
  • connectionString
    • Type:String
    • Description:Represents the connection string to the database
  • tableName
    • Type:String
    • Description:Represents the name for the table
  • 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
    • Description:Indicates whether need to overwrite the datatable if there's already an exsited one

Protected Methods

1BU=(IEnumerable<String>)

N/A

Remarks

N/A

Return Value
  • Type:Boolean
  • Description:N/A
Parameters
  • returningColumnNames
    • Type:IEnumerable<String>
    • Description:N/A

1xU=(GeoCanvas,Dictionary<String,Collection<Feature»,Collection<SimpleCandidate>,ZoomLevel,RectangleShape)

N/A

Remarks

N/A

Return Value
  • Type:Void
  • Description:N/A
Parameters
  • featuresForFilters
    • Type:Dictionary<String,Collection<Feature»
    • Description:N/A
  • currentZoomLevel

OnDrawingFeatures(DrawingFeaturesEventArgs)

N/A

Remarks

N/A

Return Value
  • Type:Void
  • Description:N/A
Parameters

OnDrawingWrappingFeatures(DrawingWrappingFeaturesFeatureLayerEventArgs)

N/A

Remarks

N/A

Return Value
  • Type:Void
  • Description:N/A
Parameters

DrawCore(GeoCanvas,Collection<SimpleCandidate>)

N/A

Remarks

N/A

Return Value
  • Type:Void
  • Description:N/A
Parameters

SetupTools()

N/A

Remarks

N/A

Return Value
  • Type:Void
  • Description:N/A
Parameters

SetupToolsCore()

N/A

Remarks

N/A

Return Value
  • Type:Void
  • Description:N/A
Parameters

OpenCore()

N/A

Remarks

N/A

Return Value
  • Type:Void
  • Description:N/A
Parameters

CloseCore()

N/A

Remarks

N/A

Return Value
  • Type:Void
  • Description:N/A
Parameters

GetBoundingBoxCore()

N/A

Remarks

N/A

Return Value
Parameters

OnRequestedDrawing(RequestedDrawingLayerEventArgs)

N/A

Remarks

N/A

Return Value
  • Type:Void
  • Description:N/A
Parameters

OnRequestingDrawing(RequestingDrawingLayerEventArgs)

N/A

Remarks

N/A

Return Value
  • Type:Void
  • Description:N/A
Parameters

GetThreadSafetyLevelCore()

N/A

Remarks

N/A

Return Value
Parameters

CloneDeepCore()

N/A

Remarks

N/A

Return Value
  • Type:Layer
  • Description:N/A
Parameters

DrawException(GeoCanvas,Exception)

N/A

Remarks

N/A

Return Value
  • Type:Void
  • Description:N/A
Parameters
  • e
    • Type:Exception
    • Description:N/A

DrawExceptionCore(GeoCanvas,Exception)

N/A

Remarks

N/A

Return Value
  • Type:Void
  • Description:N/A
Parameters
  • e
    • Type:Exception
    • Description:N/A

OnDrawingException(DrawingExceptionLayerEventArgs)

N/A

Remarks

N/A

Return Value
  • Type:Void
  • Description:N/A
Parameters

OnDrawnException(DrawnExceptionLayerEventArgs)

N/A

Remarks

N/A

Return Value
  • Type:Void
  • Description:N/A
Parameters

DrawAttributionCore(GeoCanvas,String)

N/A

Remarks

N/A

Return Value
  • Type:Void
  • Description:N/A
Parameters
  • attribution
    • Type:String
    • Description:N/A

OnDrawingAttribution(DrawingAttributionLayerEventArgs)

N/A

Remarks

N/A

Return Value
  • Type:Void
  • Description:N/A
Parameters

OnDrawnAttribution(DrawnAttributionLayerEventArgs)

N/A

Remarks

N/A

Return Value
  • Type:Void
  • Description:N/A
Parameters

OnDrawingProgressChanged(DrawingProgressChangedEventArgs)

N/A

Remarks

N/A

Return Value
  • Type:Void
  • Description:N/A
Parameters

Finalize()

N/A

Remarks

N/A

Return Value
  • Type:Void
  • Description:N/A
Parameters

MemberwiseClone()

N/A

Remarks

N/A

Return Value
  • Type:Object
  • Description:N/A
Parameters

Public Properties

CommandTimeout

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

Remarks

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

Return Value
  • Type:Int32

DatabaseConnectionMode

N/A

Remarks

N/A

Return Value

ConnectionString

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

Remarks

None

Return Value
  • Type:String

TableName

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

Remarks

None

Return Value
  • Type:String

WhereClause

N/A

Remarks

N/A

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

Remarks

The default implementation in the base class returns false.

Return Value
  • Type:Boolean

Srid

Specify what kind srid data to be used.

Remarks

N/A

Return Value
  • Type:Int32

SchemaName

N/A

Remarks

N/A

Return Value
  • Type:String

SpatialIndexName

N/A

Remarks

N/A

Return Value
  • Type:String

FeatureIdColumn

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

Remarks

None

Return Value
  • Type:String

CustomGeometryColumnName

N/A

Remarks

N/A

Return Value
  • Type:String

WrappingExtent

N/A

Remarks

N/A

Return Value

WrappingMode

N/A

Remarks

N/A

Return Value

EditTools

N/A

Remarks

N/A

Return Value

FeatureIdsToExclude

N/A

Remarks

N/A

Return Value
  • Type:Collection<String>

QueryTools

N/A

Remarks

N/A

Return Value

MaxRecordsToDraw

N/A

Remarks

N/A

Return Value
  • Type:Int32

FeatureSource

N/A

Remarks

N/A

Return Value

DrawingQuality

N/A

Remarks

N/A

Return Value

ZoomLevelSet

N/A

Remarks

N/A

Return Value

DrawingMarginPercentage

N/A

Remarks

N/A

Return Value
  • Type:Double

DrawingMarginInPixel

N/A

Remarks

N/A

Return Value
  • Type:Single

GeometryValidationMode

N/A

Remarks

N/A

Return Value

RequestDrawingInterval

N/A

Remarks

N/A

Return Value
  • Type:TimeSpan

IsOpen

N/A

Remarks

N/A

Return Value
  • Type:Boolean

DrawingTime

N/A

Remarks

N/A

Return Value
  • Type:TimeSpan

Name

N/A

Remarks

N/A

Return Value
  • Type:String

Attribution

N/A

Remarks

N/A

Return Value
  • Type:String

IsVisible

N/A

Remarks

N/A

Return Value
  • Type:Boolean

Transparency

N/A

Remarks

N/A

Return Value
  • Type:Single

BlueTranslation

N/A

Remarks

N/A

Return Value
  • Type:Single

RedTranslation

N/A

Remarks

N/A

Return Value
  • Type:Single

GreenTranslation

N/A

Remarks

N/A

Return Value
  • Type:Single

KeyColors

N/A

Remarks

N/A

Return Value

IsNegative

N/A

Remarks

N/A

Return Value
  • Type:Boolean

IsGrayscale

N/A

Remarks

N/A

Return Value
  • Type:Boolean

DrawingExceptionMode

N/A

Remarks

N/A

Return Value

Protected Properties

yhU=

N/A

Remarks

N/A

Return Value
  • Type:Int64

zRU=

N/A

Remarks

N/A

Return Value
  • Type:Int64

0BU=

N/A

Remarks

N/A

Return Value
  • Type:TimeSpan

0xU=

N/A

Remarks

N/A

Return Value
  • Type:TimeSpan

IsOpenCore

N/A

Remarks

N/A

Return Value
  • Type:Boolean

Public Events

DrawingFeatures N/A

Remarks

N/A

Event Arguments:DrawingFeaturesEventArgs

DrawingWrappingFeatures N/A

Remarks

N/A

Event Arguments:DrawingWrappingFeaturesFeatureLayerEventArgs

RequestedDrawing N/A

Remarks

N/A

Event Arguments:RequestedDrawingLayerEventArgs

RequestingDrawing N/A

Remarks

N/A

Event Arguments:RequestingDrawingLayerEventArgs

DrawingProgressChanged N/A

Remarks

N/A

Event Arguments:DrawingProgressChangedEventArgs

DrawingException N/A

Remarks

N/A

Event Arguments:DrawingExceptionLayerEventArgs

DrawnException N/A

Remarks

N/A

Event Arguments:DrawnExceptionLayerEventArgs

DrawingAttribution N/A

Remarks

N/A

Event Arguments:DrawingAttributionLayerEventArgs

DrawnAttribution N/A

Remarks

N/A

Event Arguments:DrawnAttributionLayerEventArgs

1) 0 2,1 1,2 2),(1 1,1 0
thinkgeo.mapsuite.portablecore.mssql2008featurelayer.txt · Last modified: 2017/03/16 21:59 (external edit)