SqlGeography.InstanceOf Method (String)

  • Article

 

Applies To: SQL Server 2016 Preview

Tests if the SqlGeography instance is the same as the specified type.

Namespace:   Microsoft.SqlServer.Types
Assembly:  Microsoft.SqlServer.Types (in Microsoft.SqlServer.Types.dll)

Syntax

[SqlMethodAttribute(IsDeterministic = true, IsPrecise = true)]
public SqlBoolean InstanceOf(
    string geometryType
)

public:
[SqlMethodAttribute(IsDeterministic = true, IsPrecise = true)]
SqlBoolean InstanceOf(
    String^ geometryType
)

[<SqlMethodAttribute(IsDeterministic = true, IsPrecise = true)>]
member InstanceOf : 
        geometryType:string -> SqlBoolean

<SqlMethodAttribute(IsDeterministic := True, IsPrecise := True)>
Public Function InstanceOf (
    geometryType As String
) As SqlBoolean

Parameters

  • geometryType
    Type: System.String

    A string that specifies one of the 12 types exposed in the geography type hierarchy.

Return Value

Type: System.Data.SqlTypes.SqlBoolean

A SqlBoolean value that indicates whether the SqlGeography instance is the same as the specified geometry type.

Returns true if the type of a geography instance is the same as the specified type, or if the specified type is an ancestor of the instance type; otherwise, returns false.

Remarks

The input for the method must be one of the following: T:Microsoft.SqlServer.Types.SqlGeometry, Point, Curve, LineString, Surface, Polygon, GeometryCollection, MultiSurface, MultiPolygon, MultiCurve, MultiLineString, and MultiPoint.

This method throws an ArgumentException if any other strings are used for the input.

See Also

SqlGeography Class
Microsoft.SqlServer.Types Namespace

Return to top