private static void RetrieveDaysInBattle()
{
var battles = businessDbContext.Battles.Select
(b => new
{
b.Name,
Days = BusinessDBContext.DaysInBattle(b.StartDate, b.EndDate)
})
.ToList();
}
public void QueryWithFunction()
{
var inMemoryOptions = new DbContextOptionsBuilder <BusinessDBContext>()
.UseInMemoryDatabase("QueryWithFunction").Options;
var context = new BusinessDBContext(inMemoryOptions);
SeedData(context);
var battles = context.Battles.Select(
b => new
{
b.Name,
Days = BusinessDBContext.DaysInBattle(b.StartDate, b.EndDate)
})
.ToList();
Assert.AreNotEqual(0, battles.Count());
}