public void SqlQueryable_SingleOrDefault() { // Prepare the test data string[] fields = new[] { "Id", "Name" }; IQueryable <Record> queryable = new SqliteQueryable(connection, "Course", "Alias", fields); // Perform the test operation Record record = queryable.SingleOrDefault(); }
public void SqlQueryable_SingleOrDefault_Predicate() { // Prepare the test data string[] fields = new[] { "Id", "Name" }; IQueryable <Record> queryable = new SqliteQueryable(connection, "Course", "Alias", fields); // Perform the test operation Record record = queryable.SingleOrDefault(x => (int)x["Alias"]["Id"] == 2); // Check the test result Assert.AreEqual(2L, record["Alias"]["Id"]); }