I'm using Dapper to hammer out some load testing tools that need to access a PostgreSQL database. This particular version of PostgreSQL does not support GUIDs natively, so GUID values are stored as 32 character strings. The values are converted to strings using someGuid.ToString("N")
, conversion back to Guid can be done using new Guid(stringValueFromColumn)
.
My question is how do I get Dapper to read the strings and convert them back to Guids?
I tried modifying the DbType mapping but that doesn't work.