public void IsGeographyColumn_returns_true_for_geography_column()
{
var dbGeography = DbGeography.FromText("POINT (90 50)");
var mockSqlDataReader = CreateSqlDataReaderWrapper(dbGeography.ProviderValue, "sys.geography");
var sqlSpatialDataReader = new SqlSpatialDataReader(SqlSpatialServices.Instance, mockSqlDataReader);
Assert.True(sqlSpatialDataReader.IsGeographyColumn(0));
}
public void IsGeometryColumn_returns_false_for_geography_column()
{
var dbGeography = DbGeography.FromText("POINT (90 50)");
var mockSqlDataReader = CreateSqlDataReaderWrapper(dbGeography.ProviderValue, "sys.geography");
var sqlSpatialDataReader = new SqlSpatialDataReader(SqlSpatialServices.Instance, mockSqlDataReader);
Assert.False(sqlSpatialDataReader.IsGeometryColumn(0));
}
public void GetGeometryAsync_roundtrips_DbGeometry()
{
var dbGeometry = DbGeometry.FromText("POINT (90 50)");
var sqlDataReaderWrapper = CreateSqlDataReaderWrapper(dbGeometry.ProviderValue, "sys.geometry");
var sqlSpatialDataReader = new SqlSpatialDataReader(SqlSpatialServices.Instance, sqlDataReaderWrapper);
var convertedDbGeometry = sqlSpatialDataReader.GetGeometryAsync(0, CancellationToken.None).Result;
Assert.Equal(dbGeometry.WellKnownValue.WellKnownText, convertedDbGeometry.WellKnownValue.WellKnownText);
}
public void GetGeometry_roundtrips_DbGeometry()
{
var dbGeometry = DbGeometry.FromText("POINT (90 50)");
var mockSqlDataReader = CreateSqlDataReaderWrapper(dbGeometry.ProviderValue, "sys.geometry");
var sqlSpatialDataReader = new SqlSpatialDataReader(SqlSpatialServices.Instance, mockSqlDataReader);
var convertedDbGeometry = sqlSpatialDataReader.GetGeometry(0);
Assert.Equal(dbGeometry.WellKnownValue.WellKnownText, convertedDbGeometry.WellKnownValue.WellKnownText);
}
public void GetGeometryAsync_roundtrips_DbGeometry()
{
var dbGeometry = DbGeometry.FromText("POINT (90 50)");
var sqlDataReaderWrapper = CreateSqlDataReaderWrapper(dbGeometry.ProviderValue, "sys.geometry");
var sqlSpatialDataReader = new SqlSpatialDataReader(SqlSpatialServices.Instance, sqlDataReaderWrapper);
var convertedDbGeometry = sqlSpatialDataReader.GetGeometryAsync(0).Result;
Assert.Equal(dbGeometry.WellKnownValue.WellKnownText, convertedDbGeometry.WellKnownValue.WellKnownText);
}
