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