public void FluentInterfaceTest_With_Many()
{
int recordsToCreate = 1000;
using (var ds = new SQLiteDatastore())
{
ds.Execute(TestDBBuilder.CREATE_MULTIPROPTABLE);
ds.BeginTransaction();
for (int i = 1; i <= recordsToCreate; i++)
{
ds.Execute(string.Format(" INSERT INTO MultiPropTable (IntField, NIntField) VALUES ({0}, {0});\r\n", i));
}
ds.CommitTransaction();
Assert.Equal(recordsToCreate, ds.GetRowCount("MultiPropTable", null));
StartTimer();
var result = ds.From <POCOMultiTypeObject>().Limit(5000, 0).Query();
EndTimer();
result.Should().NotBeEmpty();
result.Should().HaveCount(recordsToCreate);
foreach (DOMultiPropType item in
ds.From <DOMultiPropType>().Read())
{
item.FloatField = 1.0F;
ds.Update(item);
}
}
}
