I have the following challenge. Im using dapper to access 2 databases in the same codebase.

Database 1: Uses UTC dates (i could change this but would not like to do that)
Database 2: Uses LocalDates (not something i can change)

These typehandlers are static, what means not repository/connectionstring specific

SqlMapper.AddTypeHandler(new DateTimeUtcHelper());

Any idea's how to solve this problem?

(Could implement datetimeoffset in Database 1 so the datatype is different)