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