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