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); } }