public void Can_insert_and_select_GeoPoint() { using (var db = OpenDbConnection()) { db.DropAndCreateTable<James>(); var james = new James { loc = SqlGeography.Point(40.6898329, -74.0452177, 4326) }; db.Insert(james); var result = db.SingleById<James>(1); result.PrintDump(); Assert.That(result.id, Is.EqualTo(1)); Assert.That(result.loc.Lat, Is.EqualTo(james.loc.Lat)); Assert.That(result.loc.Long, Is.EqualTo(james.loc.Long)); Assert.That(result.loc.STSrid, Is.EqualTo(james.loc.STSrid)); } }
public void Can_insert_and_select_GeoPoint() { using (var db = OpenDbConnection()) { db.DropAndCreateTable <James>(); var james = new James { loc = SqlGeography.Point(40.6898329, -74.0452177, 4326) }; db.Insert(james); var result = db.SingleById <James>(1); result.PrintDump(); Assert.That(result.id, Is.EqualTo(1)); Assert.That(result.loc.Lat, Is.EqualTo(james.loc.Lat)); Assert.That(result.loc.Long, Is.EqualTo(james.loc.Long)); Assert.That(result.loc.STSrid, Is.EqualTo(james.loc.STSrid)); } }