public void TestDbRepositorySpatialsNullCrudAsync()
{
// Setup
var entity = new SpatialsClass
{
SessionId = Guid.NewGuid(),
ColumnGeography = null,
ColumnGeometry = null
};
using (var repository = new DbRepository <SqlConnection>(Database.ConnectionStringForRepoDb))
{
// Act Insert
var insertResult = repository.InsertAsync(entity);
var id = insertResult.Result;
// Act Query
var queryResult = repository.QueryAsync <SpatialsClass>(e => e.SessionId == (Guid)id);
var data = queryResult.Result.FirstOrDefault();
// Assert
Assert.IsNotNull(data);
Assert.IsNull(data.ColumnGeography);
Assert.IsNull(data.ColumnGeometry);
}
}
public void TestDbRepositorySpatialsCrudAsync()
{
// Setup
var entity = new SpatialsClass
{
SessionId = Guid.NewGuid(),
ColumnGeography = "POLYGON ((0 0, 50 0, 50 50, 0 50, 0 0))",
ColumnGeometry = "LINESTRING (-122.36 47.656, -122.343 47.656)"
};
using (var repository = new DbRepository <SqlConnection>(Database.ConnectionStringForRepoDb))
{
// Act Insert
var insertResult = repository.InsertAsync(entity);
var id = insertResult.Result;
// Act Query
var queryResult = repository.QueryAsync <SpatialsClass>(e => e.SessionId == (Guid)id);
var data = queryResult.Result.FirstOrDefault();
// Assert
Assert.IsNotNull(data);
Assert.AreEqual(entity.ColumnGeography.ToString(), data.ColumnGeography?.ToString());
Assert.AreEqual(entity.ColumnGeometry.ToString(), data.ColumnGeometry?.ToString());
}
}
public void TestBaseRepositorySpatialsNullCrud()
{
// Setup
var entity = new SpatialsClass
{
SessionId = Guid.NewGuid(),
ColumnGeography = null,
ColumnGeometry = null
};
using (var repository = new SpatialsClassRepository(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.ColumnGeography);
Assert.IsNull(data.ColumnGeometry);
}
}
public void TestSqlConnectionSpatialsCrud()
{
// Setup
var entity = new SpatialsClass
{
SessionId = Guid.NewGuid(),
ColumnGeography = "POLYGON ((0 0, 50 0, 50 50, 0 50, 0 0))",
ColumnGeometry = "LINESTRING (-122.36 47.656, -122.343 47.656)"
};
using (var connection = new SqlConnection(Database.ConnectionStringForRepoDb))
{
// Act Insert
var id = connection.Insert(entity);
// Act Query
var data = connection.Query <SpatialsClass>(e => e.SessionId == (Guid)id).FirstOrDefault();
// Assert
Assert.IsNotNull(data);
Assert.AreEqual(entity.ColumnGeography.ToString(), data.ColumnGeography?.ToString());
Assert.AreEqual(entity.ColumnGeometry.ToString(), data.ColumnGeometry?.ToString());
}
}
