Dapper Tutorial - Knowledge Base (KB)

Using Dapper with SQL Spatial Types as a parameter

I've got a system which basically has to do a query like this:...SELECT * FROM MyTable WHERE @parameter.STIntersects(MyGeometryColumn) ...This is quite simple to do when using vanilla SQL parameters, you just have to create your parameter in a non-typical...

Dapper Spatial Geography Type

I'm cooking up some spatial examples and have decided to give Dapper a go, although EF has spatial support, and I'm loving having control over my SQL again (Thanks Sam & Marc)....However, I need to be able to have POCO's that support the ...DbGeography...

Query spatial data with dapper

I've found some related ...questions..., but the author gave up and went ahead with using stored procedures to do the 'mapping'....This is actually a continuation question from ...here...Model...public class Store { public int Id { get; private set; }...

dapper.fastcrud doesn't mapped geometry data from postgresql

I have a spatial data in Postgresql. For example table planet_osm_point has 2 attributes:...CREATE TABLE public.planet_osm_point ( osm_id bigint, way geometry(Point,3857) ) ...If I use dapper to CRUD operations all work fine. But if I use Dapper.f...