public void TestBaseRepositorySpatialsMappedNullCrudAsync() { // Setup var entity = new SpatialsMapClass { SessionId = Guid.NewGuid(), ColumnGeographyMapped = null, ColumnGeometryMapped = null }; using (var repository = new SpatialsMapClassRepository(Database.ConnectionStringForRepoDb)) { // Act Insert var insertResult = repository.InsertAsync(entity); var id = insertResult.Result; // Act Query var queryResult = repository.QueryAsync(e => e.SessionId == (Guid)id); var data = queryResult.Result.FirstOrDefault(); // Assert Assert.IsNotNull(data); Assert.IsNull(data.ColumnGeographyMapped); Assert.IsNull(data.ColumnGeometryMapped); } }
public void TestBaseRepositorySpatialsMappedCrudAsync() { // 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 insertResult = repository.InsertAsync(entity); var id = insertResult.Result; // Act Query var queryResult = repository.QueryAsync(e => e.SessionId == (Guid)id); var data = queryResult.Result.FirstOrDefault(); // Assert Assert.IsNotNull(data); Assert.AreEqual(entity.ColumnGeographyMapped.ToString(), data.ColumnGeographyMapped?.ToString()); Assert.AreEqual(entity.ColumnGeometryMapped.ToString(), data.ColumnGeometryMapped?.ToString()); } }