sql server & .net core 使用空间数据

使用的库

Microsoft.EntityFrameworkCore.SqlServer
Microsoft.EntityFrameworkCore.SqlServer.NetTopologySuite

Startup.cs

public void ConfigureServices(IServiceCollection services)
{
    services.AddEntityFrameworkSqlServer()
             .AddDbContext<YourDbContext>(options => options.UseSqlServer(_configuration.GetConnectionString("SqlServer"),
              //映射到空间数据的数据库中的类型在模型中使用 NTS 类型
              x => x.UseNetTopologySuite()));
}

建表需要注意:Geography or geometry

By default, spatial properties are mapped to geography columns in SQL Server. To use geometry, configure the column type in your model.
默认的数据类型是geography，如果要使用geometry，需要声明
比如使用geoserver，不识别geography，则需要geometry

[Column(TypeName = "geometry")]
public Polygon Shape { get; set; }

参考资料

新增/修改数据

点

//srid=4326:wgs84
var geometryFactory = NtsGeometryServices.Instance.CreateGeometryFactory(srid: 4326);
var currentLocation = geometryFactory.CreatePoint(new Coordinate(x, y));