public void FindBooksWithCSharpInTheirTitleLike()
{
//SETUP
var sqlite = new SqliteInMemory();
using (var context = sqlite.GetContextWithSetup())
{
context.SeedDatabase(TestFileHelpers.GetSolutionDirectory() + @"\EfCoreInAction\wwwroot\");
sqlite.ClearLogs();
//ATTEMPT
var bookTitles = context.Books
.Where(p => EF.Functions.Like(p.Title, "%C#%"))
.Select(p => p.Title)
.ToList();
//VERIFY
bookTitles.Count.ShouldEqual(5);
foreach (var title in bookTitles)
{
_output.WriteLine(title);
}
}
}
public void TestEndsWith()
{
//SETUP
var sqlite = new SqliteInMemory();
using (var context = sqlite.GetContextWithSetup())
{
context.SeedDatabaseDummyBooks(40);
sqlite.ClearLogs();
//ATTEMPT
var books = context.Books
.Where(p => p.Title.EndsWith("1 Title"))
.ToList();
//VERIFY
books.Count.ShouldEqual(4);
foreach (var log in sqlite.Logs)
{
_output.WriteLine(log);
}
}
}
public void FindBooksWithCSharpInTheirTitleContains()
{
//SETUP
var sqlite = new SqliteInMemory();
using (var context = sqlite.GetContextWithSetup())
{
context.SeedDatabase(TestFileHelpers.GetSolutionDirectory() + @"\EfCoreInAction\wwwroot\");
sqlite.ClearLogs();
//ATTEMPT
var books = context.Books
.Where(p => p.Title.Contains("C#"))
.ToList();
//VERIFY
books.Count.ShouldEqual(5);
foreach (var log in sqlite.Logs)
{
_output.WriteLine(log);
}
}
}
