Proposal: add support for ILogger (Microsoft.Extensions.Logging)

[FrancescoBonizzi]

Since HttpClientFactory injects an ILogger and uses LogDebug to log requests and responses, it would be helpful to do the same with Dapper to log SQL statements. It could be a game changer when debugging!

[wizofaus]

Yep, definitely. That Dapper doesn't appear to have anything like the command interceptor in EF that allows easily logging the full SQL/parameter values when exceptions occur is a significant drawback.