ef-core-2-repository.cs

public class EFRepository
{
    public List<Product> GetAllProductsByCategory(int categoryId)
    {
        using (var db = new EFCore2TestContext())
        {
            var products = db.Product
                .Where(b => b.ProductCategoryId == categoryId)
                .OrderBy(b => b.ProductNumber)
                .Include(p => p.ProductCategory)
                .ToList();

            return products;
        }
    }
}