public async Task TestAsyncTableQueryToFirstAsyncMissing()
{
SQLiteAsyncConnection conn = GetAsyncConnection();
await conn.CreateTableAsync <Customer>();
// create...
Customer customer = CreateCustomer();
await conn.InsertAsync(customer);
// query...
AsyncTableQuery <Customer> query = conn.Table <Customer>().Where(v => v.Id == -1);
Assert.That(async() => await query.FirstAsync(), Throws.TypeOf <InvalidOperationException>());
}
public async Task TestAsyncTableQueryToFirstAsyncFound()
{
SQLiteAsyncConnection conn = GetAsyncConnection();
await conn.CreateTableAsync <Customer>();
// create...
Customer customer = CreateCustomer();
await conn.InsertAsync(customer);
// query...
AsyncTableQuery <Customer> query = conn.Table <Customer>().Where(v => v.Id == customer.Id);
var loaded = await query.FirstAsync();
// check...
Assert.AreEqual(customer.Email, loaded.Email);
}
public void TestAsyncTableQueryToFirstAsyncMissing()
{
SQLiteAsyncConnection conn = GetConnection();
conn.CreateTableAsync <Customer>().Wait();
// create...
Customer customer = CreateCustomer();
conn.InsertAsync(customer).Wait();
// query...
AsyncTableQuery <Customer> query = conn.Table <Customer>().Where(v => v.Id == -1);
Task <Customer> task = query.FirstAsync();
ExceptionAssert.Throws <AggregateException>(() => task.Wait());
}
public void TestAsyncTableQueryToFirstAsyncFound()
{
SQLiteAsyncConnection conn = GetConnection();
conn.CreateTableAsync <Customer>().Wait();
// create...
Customer customer = CreateCustomer();
conn.InsertAsync(customer).Wait();
// query...
AsyncTableQuery <Customer> query = conn.Table <Customer>().Where(v => v.Id == customer.Id);
Task <Customer> task = query.FirstAsync();
task.Wait();
Customer loaded = task.Result;
// check...
Assert.AreEqual(customer.Email, loaded.Email);
}
