Hi, I'd like to use 'decimal (x, y)' column type for C# decimals for SQL server and 'text' column type for SQLite, because SQLite converts all inserted values to doubles, and precision is lost. The ...

CREATE TABLE inventory.products (id INTEGER PRIMARY KEY, name VARCHAR(255), description VARCHAR(512), weight DECIMAL(9,3)) ...