public void TestGeographyDataType()
{
//arrange
var fixtureData = new Models.TypeMapSpatial
{
geography_column = "POLYGON ((0 0, 50 0, 50 50, 0 50, 0 0))"
};
//act
var sut = new DbRepository <SqlConnection>(Constants.TestDatabase);
var returnedId = sut.Insert(fixtureData);
//assert
var saveData = sut.Query <Models.TypeMapSpatial>(top: 1).FirstOrDefault();
saveData.ShouldNotBeNull();
saveData.geography_column.ShouldBe(fixtureData.geography_column);
}
public void TestGeometryDataType()
{
//arrange
var fixtureData = new Models.TypeMapSpatial
{
geometry_column = "LINESTRING (-122.36 47.656, -122.343 47.656)"
};
//act
var sut = new DbRepository <SqlConnection>(Constants.TestDatabase);
var returnedId = sut.Insert(fixtureData);
//TODO: support guid primary key
//assert
var saveData = sut.Query <Models.TypeMapSpatial>(top: 1).FirstOrDefault();
saveData.ShouldNotBeNull();
saveData.geometry_column.ShouldBe(fixtureData.geometry_column);
}
