Entity Framework Core - Knowledge Base (KB)

Is there a way to declare a Spatial Index with EntityFrameworkCore 2.2?

I am using ...Entity Framework Core 2.2... with ...NetTopologySuite 1.15.1... and ...SQL Server 2016.... Having a column of type ...IPoint... works great to the point I want to create an index on it....I have this table...public class Location { publi...

Calculate the geographic distance between two points using NetTopologySuite with EF Core and postgis

I am using the ...kartoza... docker image to run a postgres server with postgis. I have a database which I am consuming using an ASP.NET Core application and Enity Framework Core. The database contains a table named Park which is represented by the follow...

Entity Framework Core IndexOutOfRangeException when saving geometry using NetTopologySuite

I'm getting a ...DbUpdateException... when I call ...SaveChanges... with some geometries loaded from a shapefile. The error I get is: ...IndexOutOfRangeException: Index was outside the bounds of the array....Here is some sample code that saves two WKT pol...

Mapping geometries with EF Core 2.2, Npgsql and NetTopologySuite

I`m trying to map this class:...using NetTopologySuite.Geometries; using System.Collections.Generic; namespace Project.API.Models { public class Geo { public int Id { get; set; } public IEnumerable<Geometry> Geometries{ get; set; ...

Entity Framework Core 3.1 with NetTopologySuite.Geometries.Point: SqlException: The supplied value is not a valid instance of data type geography

I have a model that looks like this:...public class Facility { [Key] [DatabaseGenerated(DatabaseGeneratedOption.Identity)] public int Id { get; set; } public NetTopologySuite.Geometries.Point Location { get; set; } } ...Test code for addi...

How to Buffer a Point (Geography) by 1 Meter in Entity Framework Core with Net Topology Suite

I'm using Entity Framework Core (3.1.0) with the Net Topology Suite packages as is ...recommended here..., and I'm having a very hard time buffering a point to create a circle polygon around it. If I pass a value of ...1... to ...Buffer()..., where I'm un...

Xamarin forms get places in the map area

I develop a xamarin forms app where I store some places in my database. I store Location NetTopology suite with efcore with latitude and longitude. Then I can find the closest places from a point on the map....But if i move the map or zoom out how can I f...