private static void ValidateSavedValues(ArubaCeContext context, ArubaAllCeTypes allTypes, decimal value) { var saved = context.AllTypes.AsNoTracking().Single(t => t.c1_int == allTypes.c1_int); Assert.Equal(value, saved.c7_decimal_28_4); Assert.Equal(value, saved.c8_numeric_28_4); }
public void SQL_Compact_always_truncates_money_on_insert_or_update() { using (var context = new ArubaCeContext("Scenario_Use_SqlCe_AppConfig_connection_string")) { context.Database.Initialize(force: false); using (context.Database.BeginTransaction()) { // Insert var allTypes = context.AllTypes.Add( new ArubaAllCeTypes { c11_money = 9.88888888888888888888888888888888m, c5_datetime = DateTime.Now, }); context.SaveChanges(); Assert.Equal(9.8888m, context.AllTypes.AsNoTracking().Single(t => t.c1_int == allTypes.c1_int).c11_money); // Update allTypes.c11_money = 11.88888888888888888888888888888888m; context.SaveChanges(); Assert.Equal(11.8888m, context.AllTypes.AsNoTracking().Single(t => t.c1_int == allTypes.c1_int).c11_money); } } }
public void SQL_Compact_does_not_truncate_decimals_on_insert_or_update() { using (var context = new ArubaCeContext("Scenario_Use_SqlCe_AppConfig_connection_string")) { context.Database.Initialize(force: false); using (context.Database.BeginTransaction()) { // Insert var allTypes = context.AllTypes.Add( new ArubaAllCeTypes { c7_decimal_28_4 = 9.88888888888888888888888888888888m, c8_numeric_28_4 = 9.88888888888888888888888888888888m, c5_datetime = DateTime.Now, }); context.SaveChanges(); ValidateSavedValues(context, allTypes, 9.8889m); // Update allTypes.c7_decimal_28_4 = 11.88888888888888888888888888888888m; allTypes.c8_numeric_28_4 = 11.88888888888888888888888888888888m; context.SaveChanges(); ValidateSavedValues(context, allTypes, 11.8889m); } } }