public List <Authors> GetUsersWithEF()
{
using (var db = new EFCore2TestContext())
{
return(db.Authors.FromSql("Select top 5000 * from Authors").AsNoTracking().ToList());
//return db.UsersGeneral.Take(5000).AsNoTracking().ToList();
}
}
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);
}
}
