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 TestGetSolutionDirectoryOk()
{
//SETUP
//ATTEMPT
var testDir = TestFileHelpers.GetSolutionDirectory();
//VERIFY
testDir.EndsWith(@"EfCoreInAction").ShouldBeTrue(testDir);
}
public void TestGetChecksumOk()
{
//SETUP
var mvc5ImagePath = Path.Combine(TestFileHelpers.GetSolutionDirectory(),
"WebApplication.Mvc5\\images\\annoyed-cat.jpg");
var fileSize = File.ReadAllBytes(mvc5ImagePath).Length;
//ATTEMPT
using (new TimerToConsole($"GetChecksumBasedOnFileContent - file size {fileSize:#,###} bytes"))
{
var output = BowerBundlerHelper.GetChecksumBasedOnFileContent(mvc5ImagePath);
}
//VERIFY
}
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);
}
}
}