Support DateOnly that was added in Dapper 2.1.37

[Dean-NC]

I'd like to use DateOnly since it was added to Dapper 2.1.37, but AOT 1.0.31 throws an error when using it with queries like IDbConnection.QueryAsync

InvalidCastException: Invalid cast from 'System.DateTime' to 'System.DateOnly'

[mgravell]

Core bits:

• test a DTO type in and out with DateOnly and (separately) TimeOnly
• setting parameter values will probably "just work"
• reading values needs to be sure to use the <T> version of GetValue
• reading output / inputoutput parameter values might need love

Note that it requires provider support; it will not work on System.Data.SqlClient; it should work on recent Microsoft.Data.SqlClient and NpgSql

[Dean-NC]

@mgravell I use Microsoft.Data.SqlClient and SQL Server 2019. The issue is only with querying, not inserting.

Here's a tiny project that reproduces it using Dapper 2.1.37, AOT 1.0.31, Microsoft.Data.SqlClient 5.2.1. The table has a Date column, and the DTO a corresponding DateOnly property.

DapperAotDateOnly.zip

Run CreateTable.sql, and in Program.cs change dbName constant to your db name.