public int GetProductStock(int productId)
{
// Microsoft Doc
var query = _context.Products
.Where(x => x.ProductID == productId)
.Select(d => AdventureWorksContextDI.GetProductStock(d.ProductID));
// Exemple of externalized in static class as static function
query = _context.Products
.Where(x => x.ProductID == productId)
.Select(d => ScalarFunctionsHelpers.GetProductStock(d.ProductID));
// Exemple of externalized in static class as extension method
query = _context.Products
.Where(x => x.ProductID == productId)
.Select(d => d.GetProductStock(d.ProductID));
return(query.FirstOrDefault());
}
public EfQueriesDI(AdventureWorksContextDI context)
{
_context = context;
}
