I am working on a project using Entity Framework Core and a databasewith geospatial support. I need to perform the following operations:
- Filter entities based on distance from a given latitude and longitude.
- *pply pagination (e.g., retrieving page 2 with a size of 10).
Currently, I am struggling to integrate these features in a single query using Entity Framework Core. Specifically, I am looking for support for geospatial queries (e.g., ST_Distance) combined with Skip and Take for pagination.
