public void TestBaseRepositorySpatialsMappedCrud()
{
// Setup
var entity = new SpatialsMapClass
{
SessionId = Guid.NewGuid(),
ColumnGeographyMapped = "POLYGON ((0 0, 50 0, 50 50, 0 50, 0 0))",
ColumnGeometryMapped = "LINESTRING (-122.36 47.656, -122.343 47.656)"
};
using (var repository = new SpatialsMapClassRepository(Database.ConnectionStringForRepoDb))
{
// Act Insert
var id = repository.Insert(entity);
// Act Query
var data = repository.Query(e => e.SessionId == (Guid)id).FirstOrDefault();
// Assert
Assert.IsNotNull(data);
Assert.AreEqual(entity.ColumnGeographyMapped.ToString(), data.ColumnGeographyMapped?.ToString());
Assert.AreEqual(entity.ColumnGeometryMapped.ToString(), data.ColumnGeometryMapped?.ToString());
}
}
public void TestBaseRepositorySpatialsMappedNullCrud()
{
// Setup
var entity = new SpatialsMapClass
{
SessionId = Guid.NewGuid(),
ColumnGeographyMapped = null,
ColumnGeometryMapped = null
};
using (var repository = new SpatialsMapClassRepository(Database.ConnectionStringForRepoDb))
{
// Act Insert
var id = repository.Insert(entity);
// Act Query
var data = repository.Query(e => e.SessionId == (Guid)id).FirstOrDefault();
// Assert
Assert.IsNotNull(data);
Assert.IsNull(data.ColumnGeographyMapped);
Assert.IsNull(data.ColumnGeometryMapped);
}
}