0 out of 1 rated this helpful - Rate this topic

Microsoft.SqlServer.Types Namespace

SQL Server 2008 R2

The Microsoft.SqlServer.Types namespace contains classes used when working with the HierarchyID data type and the spatial data types, such as the geometry and geographic data types.

  Class Description
Public class HierarchyIdException The exception that is thrown for invalid SqlHierarchyId values.
Public class SqlGeography The SqlGeography type represents data in a geodetic (round earth) coordinate system.
Public class SqlGeographyBuilder Constructs instances of SqlGeography objects by using IGeographySink interface.
Public class SqlGeometry The SqlGeometry type represents data in a Euclidean (flat) coordinate system.
Public class SqlGeometryBuilder Constructs instances of SqlGeometry objects by using IGeometrySink interface.
  Structure Description
Public structure SqlHierarchyId The SqlHierarchyId type represents a position in a hierarchical structure, specifying depth and breadth.
  Interface Description
Public interface IGeographySink Interface used by SqlGeographyBuilder to construct a SqlGeography object.
Public interface IGeometrySink Defines the interface that the SqlGeometryBuilder class uses to construct a SqlGeometryBuilder object.
  Enumeration Description
Public enumeration OpenGisGeographyType Lists Open GIS geography types.
Public enumeration OpenGisGeometryType Lists Open GIS geometry types.
Did you find this helpful?
(1500 characters remaining)
Community Content Add
Annotations FAQ
I can't see the dll in the folder path provided
Hi I have Igeography property in my class but it's giving me an error that namespace could not be found so I searched. I can;t find it in the folder you suggested (C:\Program Files\Microsoft SQL Server\100\SDK\Assemblies). The nearest dll after .SString is Microsoft.SqlServer.TxScript. No Microsoft.SqlServer.Type.
I am using sql server 2008 r2. what am I missing? thanks

Nevermind. FOund it in here C:\Program Files (x86)\Microsoft SQL Server\100\SDK\Assemblies
@Brian
You should find it in the GAC (%windir%\assembly) and in %programfiles%\Microsoft SQL Server\100\SDK\Assemblies.  The file is Microsoft.SqlServer.Types.dll.
How about telling us which dll contains this namespace?
How about telling us which dll contains this namespace?