使用的库
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));