Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

SqlGeometry.Deserialize Method (SqlBytes)


Applies To: SQL Server 2016 Preview

Returns a constructed SqlGeometry from an internal SQL Server format for spatial data.

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

static member Deserialize : 
        bytes:SqlBytes -> SqlGeometry


Type: System.Data.SqlTypes.SqlBytes

A SqlBytes that specifies the spatial data being sent over the network.

Return Value

Type: Microsoft.SqlServer.Types.SqlGeometry

A SqlGeometry instance that represents the constructed geometry object being sent over the network.

This can be used for reading bytes sent from the server through SqlDataReader. Useful for sending spatial data over the network in conjunction with Serialize().

Legacy Code Example

using (SqlConnection conn = new SqlConnection("..."))
      SqlCommand cmd = new SqlCommand("SELECT [SpatialData] FROM [SpatialTable]", conn);
      using (SqlDataReader rdr = cmd.ExecuteReader())
            while (rdr.Read())
                  SqlGeometry g = SqlGeometry.Deserialize(reader.GetSqlBytes(0).Stream));
                                                // do some spatial work


Return to top
© 2015 Microsoft