public void TestUpsert()
{
Categories category = new Categories
{
CategoryID = 11,
CategoryName = "Drink",
Description = "Coke",
};
Query.Upsert(category.AsEnumerable());
var L = Query.Select <Categories>(row => row.CategoryID == 11);
string text = L.First().ToSimpleString();
Debug.Assert(text == "{CategoryID:11, CategoryName:Drink, Description:Coke, Picture:}");
}