I have an existing database that uses the SQL time(7) type, which does not map directly to a .Net type.
Question: Using Dapper, how do I map a SQL time column to a .Net type?
Issue: When I attempt to implicitly map a SQL time(7) column to DateTime using Dapper-dot-net, I get the following exception:
An exception of type 'System.Data.DataException' occurred in Dapper.dll but was not handled in user code
Additional information: Error parsing column 5 (CheckInTime=08:54:43.1470000 - Object)
I assumed it would map to DateTime automatically, but it does not appear to do so