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