I am simply inserting data using [c#, DAPPER, MS Access] inside a table but the column which is [DateTime] in c# is mapped to [date/time] column in MsAccess cause a issue like "data mismatch in criteria expression".
After a long research I got a link, but the "Floor" solution doesn't work here. Any suggestions are most welcome.
The best solution I found is changing the parameter syntax inside the query string from
The reason for this is explained in https://github.com/StackExchange/Dapper/issues/911