EFCore.BulkExtensions icon indicating copy to clipboard operation
EFCore.BulkExtensions copied to clipboard

Question: Do EFCore.BulkExtensions support postgresql/postgis geometry type?

Open swidz opened this issue 3 years ago • 1 comments

Hi, Is PostgreSQL/PostGis geometry type supported? When I try to bulk insert list of entities containing a geometry property I get the following error: A PostgreSQL type with the name geometry (point, 2180) was not found in the database

Geometry type is defined using NetTopologySuite. Postgis 3.2 Extension is installed. There are no issues when adding entities using AddRange and SaveChanges.

Location property is defined as follows:

builder.Property(x => x.Location)
                .HasColumnType("geometry (point, 2180)")
                .HasSrid(2180);

swidz avatar Apr 04 '22 20:04 swidz

Not yet, at the moment that feature only for SqlServer.

borisdj avatar Apr 14 '22 20:04 borisdj

Support added, new Nuget will be published in a few days.

borisdj avatar May 11 '23 13:05 borisdj