public void ShouldGetOrderTotalWithFunction()
{
var order = _db.Orders.First(x => StoreContext.GetOrderTotal(x.Id) == 4424.90M);
Assert.NotNull(order);
Assert.Equal(4424.90M, order.OrderTotal ?? 0);
}
private static void GetRecordsOver(decimal amount)
{
using var db = new StoreContext();
foreach (var order in db.Orders.Where(x => StoreContext.GetOrderTotal(x.Id) > amount))
{
Console.WriteLine($"Qty: {order.CustomerId}, Total: {order.OrderTotal}");
}
}
public void ShouldFilterWithMappedFunction()
{
ExecuteInATransaction(RunTheTest);
void RunTheTest()
{
//CreateCategoryAndProducts();
//Execution happens
Context.CustomerId = 1;
var cats = Context.Orders
.Where(x => x.OrderTotal > StoreContext.GetOrderTotal(4))
.ToList();
}
}