PetaPoco and Spatial Data Types

PetaPoco is a micro-ORM for .NET and Mono. If you haven’t see it yet I suggest you to check it out. Alternatives to PetaPoco are Massive and Dapper. (If you know more projects let me know).

After this brief introduction let me begin by explaining the problem. I need it to build a simple web app with a fairly simple data model that was using Spatial Data. The app would use SQL Server 2008.

Let’s consider a table with a bunch of columns and one of them is a geometry column. [read more…]