Re: Trouble with decimal precision and scale using Code First

[Jared Jensen]

Good to know, thanks. I'm currently working around this limitation for my currency fields with this approach in my DB initalizer:

// Fix currency fields
var currency = new Dictionary<string, string[]>();
currency.Add("Account", new[] { "BillingAmount" });
...(more tables/fields)...
currency.Add("Settings", new[] { "ReturnedPaymentFee", "SalesTaxRate", "ScannerStopBits" });
currency.Add("User", new[] { "HourlyWage" });
foreach (var table in currency.Keys) {
foreach (var field in currency[table]) {
context.Database.ExecuteSqlCommand(String.Format("ALTER TABLE `{0}` CHANGE `{1}` `{1}` DECIMAL(19,4) NOT NULL", table, field));
}
}