Tutorial by Examples

install the required Microsoft.SqlServer.Types assembly; they are not installed by default, and are available from Microsoft here as "Microsoft® System CLR Types for Microsoft® SQL Server® 2012" - note that there are separate installers for x86 and x64. install Dapper.EntityFramew...

Once the type handlers are registered, everything should work automatically, and you should be able to use these types as either parameters or return values: string redmond = "POINT (122.1215 47.6740)"; DbGeography point = DbGeography.PointFromText(redmond, DbGeography.DefaultCoordi...