Is possible to configure different DbType for a column for different database (or IDataProvider)

[alexey-leonovich]

Hello.
Depending on config file my app connects to SQL Server Compact or SQLite database. In one of my domain objects I have a field representing transaction sum (decimal C# type).
In SQL Server Compact I can safely use [Column(DbType = "numeric(29,4)"] annotation as this database supports decimal natively.
SQLite uses REAL affinity (floating-point) for a decimal value and promises to preserve the 15 most significant digits. So to preserve precision in my computations I want to use [Column(DbType = "numeric(15,4)"] annotation, but only for SQLite.
Is possible to configure different DbType for a column for different database (or IDataProvider)? For example in EF Core it can be done inside protected override void OnModelCreating(ModelBuilder builder). Thank you.

[MaceWindu]

You can use multiple mapping attributes with different Configuration, which should contain connection name (or at least provider name):

[Column(DataType = DataType.Decimal, Configration = "MySqlCeConnection")]
[Column(DataType = DataType.Double, Configration = "MySQLiteConnection")]