Different TypeHandler for different database types

Hi,

is there a way to tell Dapper to use specific TypeHandlers depending on the type of database (e.g. SQLite/SQL Server/MySQL/etc.) that is being queried?

My situation:
I am using Dapper to query data from a SQLite db and a SQL Server db in the same application.

For SQLite I have implemented some custom TypeHandlers.
For example I have a TypeHandler that converts System.DateTime values to strings and strings back to DateTimes.

This causes a problem now, when I use Dapper to query data from SQL Server.
SQL Server (more precisely the SQL Server ADO.NET provider) already returns datetime values as instances of the System.DateTime type, but my (SQLite specific) TypeHandler expects date times values to be retrieved as strings from the database.

Now, I know I could examine the value returned from the database in my TypeHandler and act accordingly, but there are some downsides to this approach.

Ideally I would like Dapper to use one TypeHandler for SQLite and another for SQL Server.

Is this possible?
Or is there maybe some way I can determine the database type from inside the TypeHandler?

No file, test, or entry point is identified. Start by locating Dapper's TypeHandler registration and provider interaction, then determine whether handlers can be scoped by database type; done requires a documented, tested answer or a clearly scoped implementation path.