Entity Framework–PostgreSQL–Enable spatial type support

To enable Spatial Type support for PostgreSQL you have to do an extra step when configuring your DBContext:

	services.AddDbContext<SampleContext>(options =>
	{
	options.UseNpgsql(configuration.GetConnectionString("PostgreSQL"), o => o.UseNetTopologySuite());
	});

view raw StartupGIS.cs hosted with ❤ by GitHub

Calling the UseNetTopologySuite()method activates a plugin for the Npgsql EF Core provider which enables mapping NetTopologySuite's types to PostGIS columns, and even translate many useful spatial operations to SQL. This is the recommended way to interact with spatial types in Npgsql.

To check if the PostGIS extension is installed in your database, you can add the following to your DbContext:

	public class SampleContextGis:DbContext
	{
	protected override void OnModelCreating(ModelBuilder builder)
	{
	builder.HasPostgresExtension("postgis");
	}
	}

view raw SampleContextGis.cs hosted with ❤ by GitHub