public void Can_build_Predicates_To_Find_Steve_Johnson() { var database = new SqliteDatabase("Data Source=chinook.db;Version=3;"); database.Discover(); var request = database["employees"] .Where() .Between("Birthdate", new DateTime(1960, 01, 01), new DateTime(1970, 01, 01)) .Contains("Firstname", "S") .Request; var data = request.FetchDataTable(); Assert.Equal(1, data.Rows.Count); // Expected number of rows Assert.Equal("Steve", data.Rows[0]["FirstName"]); Assert.Equal("Johnson", data.Rows[0]["LastName"]); }
public SqliteConnectedTestClass() { Database = new SqliteDatabase("Data Source=chinook.db;Version=3;"); Database.Discover(); }