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
Members Summary
Public Constructors
MsSql2008FeatureLayer()
This is the constructor for the class.
Parameters
MsSql2008FeatureLayer(String,String,String)
This is the constructor for the class.
Parameters
MsSql2008FeatureLayer(String,String,String,DatabaseConnectionMode)
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.
Parameters
MsSql2008FeatureLayer(String,String,String,Int32,String)
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
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
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.
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
Return Value
Type:Void
Description:N/A
Parameters
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 MULTILINESTRING1)
Return Value
Type:Void
Description:N/A
Parameters
GetFirstGeometryType()
Get The shape type from the first record.
Return Value
Parameters
ExecuteNonQuery(String)
This method executes a query that does not return a SQL result.
This methods executes a query that has no results.
Return Value
Type:Int32
Description:None
Parameters
RequestDrawing()
N/A
Return Value
Type:Void
Description:N/A
Parameters
RequestDrawing(RectangleShape)
N/A
Return Value
Type:Void
Description:N/A
Parameters
RequestDrawing(IEnumerable<RectangleShape>)
N/A
Return Value
Type:Void
Description:N/A
Parameters
RequestDrawing(TimeSpan)
N/A
Return Value
Type:Void
Description:N/A
Parameters
bufferTime
Type:TimeSpan
Description:N/A
RequestDrawing(TimeSpan,RequestDrawingBufferTimeType)
N/A
Return Value
Type:Void
Description:N/A
Parameters
bufferTime
Type:TimeSpan
Description:N/A
RequestDrawing(RectangleShape,TimeSpan)
N/A
Return Value
Type:Void
Description:N/A
Parameters
bufferTime
Type:TimeSpan
Description:N/A
RequestDrawing(RectangleShape,TimeSpan,RequestDrawingBufferTimeType)
N/A
Return Value
Type:Void
Description:N/A
Parameters
bufferTime
Type:TimeSpan
Description:N/A
RequestDrawing(IEnumerable<RectangleShape>,TimeSpan)
N/A
Return Value
Type:Void
Description:N/A
Parameters
bufferTime
Type:TimeSpan
Description:N/A
RequestDrawing(IEnumerable<RectangleShape>,TimeSpan,RequestDrawingBufferTimeType)
N/A
Return Value
Type:Void
Description:N/A
Parameters
bufferTime
Type:TimeSpan
Description:N/A
GetThreadSafetyLevel()
N/A
Return Value
Parameters
CloneDeep()
N/A
Return Value
Parameters
Open()
N/A
Return Value
Type:Void
Description:N/A
Parameters
Close()
N/A
Return Value
Type:Void
Description:N/A
Parameters
GetBoundingBox()
N/A
Return Value
Parameters
Draw(GeoCanvas,Collection<SimpleCandidate>)
N/A
Return Value
Type:Void
Description:N/A
Parameters
ToString()
N/A
Return Value
Type:String
Description:N/A
Parameters
Equals(Object)
N/A
Return Value
Type:Boolean
Description:N/A
Parameters
obj
Type:Object
Description:N/A
GetHashCode()
N/A
Return Value
Type:Int32
Description:N/A
Parameters
GetType()
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.
Return Value
Type:Void
Description:N/A
Parameters
CreateTable(String,String,SpatialDataType,IEnumerable<FeatureSourceColumn>)
This method creates a Sql Spatial Data table in MsSql2008 server.
Return Value
Type:Void
Description:N/A
Parameters
CreateTable(String,String,SpatialDataType,IEnumerable<FeatureSourceColumn>,OverwriteMode)
This method creates a Sql Spatial Data table in MsSql2008 server.
Return Value
Type:Void
Description:N/A
Parameters
Protected Methods
1BU=(IEnumerable<String>)
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
Return Value
Type:Void
Description:N/A
Parameters
featuresForFilters
Type:Dictionary<String,Collection<
Feature»
Description:N/A
OnDrawingFeatures(DrawingFeaturesEventArgs)
N/A
Return Value
Type:Void
Description:N/A
Parameters
OnDrawingWrappingFeatures(DrawingWrappingFeaturesFeatureLayerEventArgs)
N/A
Return Value
Type:Void
Description:N/A
Parameters
DrawCore(GeoCanvas,Collection<SimpleCandidate>)
N/A
Return Value
Type:Void
Description:N/A
Parameters
SetupTools()
N/A
Return Value
Type:Void
Description:N/A
Parameters
SetupToolsCore()
N/A
Return Value
Type:Void
Description:N/A
Parameters
OpenCore()
N/A
Return Value
Type:Void
Description:N/A
Parameters
CloseCore()
N/A
Return Value
Type:Void
Description:N/A
Parameters
GetBoundingBoxCore()
N/A
Return Value
Parameters
OnRequestedDrawing(RequestedDrawingLayerEventArgs)
N/A
Return Value
Type:Void
Description:N/A
Parameters
OnRequestingDrawing(RequestingDrawingLayerEventArgs)
N/A
Return Value
Type:Void
Description:N/A
Parameters
GetThreadSafetyLevelCore()
N/A
Return Value
Parameters
CloneDeepCore()
N/A
Return Value
Parameters
DrawException(GeoCanvas,Exception)
N/A
Return Value
Type:Void
Description:N/A
Parameters
e
Type:Exception
Description:N/A
DrawExceptionCore(GeoCanvas,Exception)
N/A
Return Value
Type:Void
Description:N/A
Parameters
e
Type:Exception
Description:N/A
OnDrawingException(DrawingExceptionLayerEventArgs)
N/A
Return Value
Type:Void
Description:N/A
Parameters
OnDrawnException(DrawnExceptionLayerEventArgs)
N/A
Return Value
Type:Void
Description:N/A
Parameters
DrawAttributionCore(GeoCanvas,String)
N/A
Return Value
Type:Void
Description:N/A
Parameters
attribution
Type:String
Description:N/A
OnDrawingAttribution(DrawingAttributionLayerEventArgs)
N/A
Return Value
Type:Void
Description:N/A
Parameters
OnDrawnAttribution(DrawnAttributionLayerEventArgs)
N/A
Return Value
Type:Void
Description:N/A
Parameters
OnDrawingProgressChanged(DrawingProgressChangedEventArgs)
N/A
Return Value
Type:Void
Description:N/A
Parameters
Finalize()
N/A
Return Value
Type:Void
Description:N/A
Parameters
MemberwiseClone()
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.
You can use this to set a time limit for the query before it times out.
Return Value
DatabaseConnectionMode
N/A
Return Value
ConnectionString
This property gets and sets the connection string that will be used to connect to the server.
Return Value
TableName
This property gets or sets the table name that the database will use.
Return Value
WhereClause
N/A
Return Value
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.
Return Value
Srid
Specify what kind srid data to be used.
Return Value
SchemaName
N/A
Return Value
SpatialIndexName
N/A
Return Value
FeatureIdColumn
This property gets or sets the name of the column that holds the unique feature Id.
Return Value
CustomGeometryColumnName
N/A
Return Value
WrappingExtent
N/A
Return Value
WrappingMode
N/A
Return Value
EditTools
N/A
Return Value
FeatureIdsToExclude
N/A
Return Value
QueryTools
N/A
Return Value
MaxRecordsToDraw
N/A
Return Value
FeatureSource
N/A
Return Value
DrawingQuality
N/A
Return Value
ZoomLevelSet
N/A
Return Value
DrawingMarginPercentage
N/A
Return Value
DrawingMarginInPixel
N/A
Return Value
GeometryValidationMode
N/A
Return Value
RequestDrawingInterval
N/A
Return Value
IsOpen
N/A
Return Value
DrawingTime
N/A
Return Value
Name
N/A
Return Value
Attribution
N/A
Return Value
IsVisible
N/A
Return Value
Transparency
N/A
Return Value
BlueTranslation
N/A
Return Value
RedTranslation
N/A
Return Value
GreenTranslation
N/A
Return Value
KeyColors
N/A
Return Value
IsNegative
N/A
Return Value
IsGrayscale
N/A
Return Value
DrawingExceptionMode
N/A
Return Value
Protected Properties
yhU=
N/A
Return Value
zRU=
N/A
Return Value
0BU=
N/A
Return Value
0xU=
N/A
Return Value
IsOpenCore
N/A
Return Value
Public Events
DrawingFeatures
N/A