Math calculation with LINQ To Entities
As with DateTime calculation, Math methods such as Abs, Ceiling, Floor, Pow, Round and Truncate are not supported by LINQ To Entities. With L2E queries, you have to use EntityFunctions methods which is not great.
With LINQ To WAQS and LINQ To Entities + WAQS, these methods are supported.
await _context.Orders.AsAsyncQueryable().Select(o => Math.Round(o.Total, 2)).ExecuteAsync();
_context.Orders.Select(o => Math.Round(o.Total, 2))
So you can write some queries using Math methods with no reference on Entity Framework.
Note that Round method is a little bit more complex than others. More details here.