public void Can_save_and_restore_JSON_property() { using (new TemporaryNamingStrategy(DialectProvider, new OrmLiteNamingStrategyBase())) { var item = new LicenseCheckTemp { Body = new CheckHistory { List = { new ItemHistory { AddedOn = DateTime.MaxValue, Note = "Test" } } } }; using (var db = OpenDbConnection()) { db.DropAndCreateTable <LicenseCheckTemp>(); db.GetLastSql().Print(); db.Save(item); } using (var db = OpenDbConnection()) { var items = db.Select <LicenseCheckTemp>(); items.PrintDump(); foreach (var licenseCheck in items.OrderBy(x => x.Id)) { if (licenseCheck.Body != null && licenseCheck.Body.List.Any()) { foreach (var itemHistory in licenseCheck.Body.List) { "{0} : Note {1}".Print(itemHistory.AddedOn, itemHistory.Note); } } } } } }
public void Can_save_and_restore_JSON_property() { using (new TemporaryNamingStrategy(new OrmLiteNamingStrategyBase())) { var item = new LicenseCheckTemp { Body = new CheckHistory { List = { new ItemHistory { AddedOn = DateTime.MaxValue, Note = "Test" } } } }; using (var db = OpenDbConnection()) { db.DropAndCreateTable<LicenseCheckTemp>(); db.GetLastSql().Print(); db.Save(item); } using (var db = OpenDbConnection()) { var items = db.Select<LicenseCheckTemp>(); items.PrintDump(); foreach (var licenseCheck in items.OrderBy(x => x.Id)) { if (licenseCheck.Body != null && licenseCheck.Body.List.Any()) { foreach (var itemHistory in licenseCheck.Body.List) { "{0} : Note {1}".Print(itemHistory.AddedOn, itemHistory.Note); } } } } } }