SqlGeometry.Deserialize Method
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)
Syntax
'Declaration
Public Shared Function Deserialize ( _
bytes As SqlBytes _
) As SqlGeometry
'Usage
Dim bytes As SqlBytes
Dim returnValue As SqlGeometry
returnValue = SqlGeometry.Deserialize(bytes)
public static SqlGeometry Deserialize(
SqlBytes bytes
)
public:
static SqlGeometry^ Deserialize(
SqlBytes^ bytes
)
static member Deserialize :
bytes:SqlBytes -> SqlGeometry
public static function Deserialize(
bytes : SqlBytes
) : SqlGeometry
Parameters
- bytes
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.
Remarks
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().
Examples
using (SqlConnection conn = new SqlConnection("..."))
{
SqlCommand cmd = new SqlCommand("SELECT [SpatialData] FROM [SpatialTable]", conn);
conn.Open();
using (SqlDataReader rdr = cmd.ExecuteReader())
{
while (rdr.Read())
{
SqlGeometry g = SqlGeometry.Deserialize(reader.GetSqlBytes(0).Stream));
// do some spatial work
}
}