Example #1
0
        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);
        }
Example #2
0
        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);
        }