IRI.Maptor.Infrastructure.EfCore 3.0.0

IRI.Maptor.Infrastructure.EfCore

EF Core persistence support for materializing SQL Server spatial columns directly into IRI.Maptor Geometry<Point> — a drop-in replacement for UseNetTopologySuite() that removes the NetTopologySuite and Microsoft.SqlServer.Types dependencies from applications. Geometry is read/written using the SQL Server native binary (MS-SSCLRT) format via IRI.Maptor.Core.Spatial's SqlServerSpatialNativeBinary serializer, so no NTS object graph or WKB round-trip is involved.

Installation

dotnet add package IRI.Maptor.Infrastructure.EfCore

Features

• Provider plugin for the SQL Server EF Core provider: UseMaptorGeometry() replaces UseNetTopologySuite()
• Reads/writes geometry and geography columns (points, lines, polygons, multi-* and geometry collections; 2D)
• SqlServerMaptorGeometryTypeMapping — the RelationalTypeMapping for Geometry<Point>
• SqlServerSpatialPassThroughTypeMapping — pass-through mapping for spatial columns in models compiled from migration snapshots/designers (SqlBytes provider-typed, or legacy NetTopologySuite Geometry), so dotnet ef migrations add/remove keep working after switching from UseNetTopologySuite()
• SqlServerMaptorGeometryTypeMappingSourcePlugin / SqlServerMaptorGeometryOptionsExtension — provider wiring
• MaptorGeometryValueComparer — reusable change-tracking comparer (SRID + WKB)
• ConfigureMaptorGeometry() convention and per-property IsGeography() / IsGeometry() configuration

Usage

Enable the provider plugin where you configure the context (replaces x.UseNetTopologySuite()):

options.UseSqlServer(connectionString, x => x.UseMaptorGeometry());

Declare geometry properties on your entities using Geometry<Point>:

using IRI.Maptor.Core.Spatial.Primitives;
using IRI.Maptor.Core.Common.Primitives;

public Geometry<Point> SHAPE { get; set; }

Choose the column type — either set a default for all geometry properties in ConfigureConventions:

protected override void ConfigureConventions(ModelConfigurationBuilder configurationBuilder)
    => configurationBuilder.ConfigureMaptorGeometry();          // maps Geometry<Point> -> geography

or per property in OnModelCreating:

entity.Property(e => e.SHAPE).IsGeography();   // or .IsGeometry()

If no column type is configured, Geometry<Point> defaults to geography.

Limitations

• Z/M columns are rejected with a clear error — store 2D data.
• Server-side spatial operators are expected via raw SQL (FromSql / FromSqlRaw, e.g. SHAPE.STIntersects(...)); LINQ spatial method translation is intentionally not provided.

NuGet package · Report issues · Back to IRI.Maptor.Infrastructure