Postgis geography type using Npgsql for EntityFramework

Question

I have a table using the Postgis geography type:

CREATE TABLE Place (
    id SERIAL PRIMARY KEY,
    name TEXT NOT NULL,
    location GEOGRAPHY NOT NULL
);

How do I declare the location field in my entity class?

class Place {
    public long id { get; set; }
    public string name { get; set; }
    public ??? location { get; set; }
}

Of course, I read this question but it was in 2014 and Npsql seems to have evolved to play with Postgis and to support .Net System.Data.Spatial. See the following Npsql issues that are now closed:

• Npgsql 3.0.3 and postgis geometry types
• PostGIS support
• Postgis 2D support
• Look into System.Data.Spatial for PostGIS
• System.Data.Spatial implementation

I couldn't find a clue in Npsql documentation about how using such features.

Answer 1

Although Npgsql does include PostGIS support, it's partial - not all types are handled, and unfortunately GEOGRAPHY is on of them.

Here's the relevant issue: https://github.com/npgsql/npgsql/issues/1322, please go post a vote.