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; }