Dapper Tutorial - Knowledge Base (KB)

How to insert DateTime (or DateTime2) with Dapper?

I'm trying to do the following:...var p = new DynamicParameters(); p.Add(...); p.Add(...); // ideally I want to insert null for end date, but I also tried DateTime.MinValue // or some other date, but doesn't help p.Add("@endDate", null, DbType.DateTime, P...

Changing the Dapper mapping for .net DateTime to use DbType DateTime2 and reinstating it back again

Similar to the question ...How can I get Dapper to map .net DateTime to DateTime2...; but I want to be able to set it back again afterwards....The currently accepted answer to that question involves changing a Dapper source file; but I'm using the NuGet p...