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);
}
}
}
}
}
}
