We recommend using Visual Studio 2017

SqlGeometry.STInteriorRingN Method

Returns the specified interior ring of a Polygon SqlGeometry instance.

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

[SqlMethodAttribute(IsDeterministic = true, IsPrecise = true)]
public SqlGeometry STInteriorRingN(
	int n


Type: System.Int32
An int expression between 1 and the number of interior rings in the SqlGeometry instance.

Return Value

Type: Microsoft.SqlServer.Types.SqlGeometry
A SqlGeometry object that represents the interior ring of the Polygon.

This method returns null if the SqlGeometry instance is not a polygon. This method will also throw an ArgumentOutOfRangeException if the expression is larger than the number of rings. The number of rings can be returned using STNumInteriorRing.

Community Additions