public void Test_Crud_UsingParameters()
{
CrudAccessor crud = new CrudAccessor();
crud.Sql(@"CREATE TABLE IF NOT EXISTS CrudItem ( Id integer PRIMARY KEY AUTOINCREMENT, Counter integer NOT NULL, String nvarchar(50) NULL );");
crud.Sql(@"DELETE FROM CrudItem;");
IList <CrudItem> newItems = Enumerable.Range(0, 20).Select(i => new CrudItem()
{
Counter = i
}).ToList();
crud.Create(newItems);
newItems.ShouldAllBe(it => it.Id > 0);
foreach (CrudItem item in newItems)
{
item.Counter *= 2;
}
crud.Update(newItems);
IList <CrudItem> getItems = crud.Get <CrudItem>();
getItems.Select(it => it.Counter).ShouldBe(Enumerable.Range(0, 20).Select(i => i * 2));
crud.Delete(getItems);
crud.Get <CrudItem>().ShouldBeEmpty();
}
public void Test_Create_UsingLiterals()
{
CrudAccessor crud = new CrudAccessor();
crud.Sql(@"CREATE TABLE IF NOT EXISTS CrudItem ( Id integer PRIMARY KEY AUTOINCREMENT, Counter integer NOT NULL, String nvarchar(50) NULL );");
crud.Sql(@"DELETE FROM CrudItem;");
IList <CrudItem> newItems = Enumerable.Range(0, 20).Select(i => new CrudItem()
{
Counter = i, String = $"String {i}"
}).ToList();
crud.CreateWithLiterals(newItems);
newItems.ShouldAllBe(it => it.Id > 0);
}