public async Task <IEnumerable <EntreeInfoResource> > GetEntreeInfoWithVegeId(int VegeId) { var entreeInfo = new List <EntreeInfoResource>(); await _context.LoadStoredProc("dbo.GetEntreeInfoById") .WithSqlParam("Id", VegeId) .WithSqlParam("Type", "Vegetable") .ExecuteStoredProcAsync((handler) => { entreeInfo = handler.ReadToList <EntreeInfoResource>().ToList(); // do something with your results. }); return(entreeInfo); }
public async Task <int> GetNumberOfEntreesWithVege(int vegeId) { // Use Store Procedure int numberOfEntreeWithVege = -1; await _context.LoadStoredProc("dbo.GetNumberOfEntreeById") .WithSqlParam("Id", vegeId) .WithSqlParam("Type", "Vegetable") .ExecuteStoredProcAsync((handler) => { numberOfEntreeWithVege = handler.ReadToValue <int> () ?? default(int);; // do something with your results. }); /* * // Use Raw SQL * await _context.LoadSQLText ("SELECT COUNT(*) AS TotalEntrees FROM EntreeVegetable WHERE VegeId = " + vegeId.ToString ()) * .ExecuteSQLTextAsync ((handler) => { * numberOfEntreeWithVege = handler.ReadToValue<int>() ?? default(int);; * // do something with your results. * }); */ /* * // Use Entity Framework Query Data * // Note: include not working in Count() * var vegetable = this._context.Vegetables.Single(v => v.Id == vegeId); * * numberOfEntreeWithVege = await this._context.Entry(vegetable) * .Collection(v => v.EntreesWithCurrentVegetable) * .Query() * .CountAsync(); */ return(numberOfEntreeWithVege); }
public async Task <int> GetNumberOfEntreesWithMeat(int meatId) { // Use Store Procedure int numberOfEntreeWithVege = -1; await _context.LoadStoredProc("dbo.GetNumberOfEntreeById") .WithSqlParam("Id", meatId) .WithSqlParam("Type", "Meat") .ExecuteStoredProcAsync((handler) => { numberOfEntreeWithVege = handler.ReadToValue <int> () ?? default(int);; // do something with your results. }); return(numberOfEntreeWithVege); }