public void OnGet() { Brokers = new GetBrokers(_ctx).Do(); Dispatches = new GetDispatches(_ctx).Do(); Drivers = new GetDrivers(_ctx).Do(); Factories = new GetFactories(_ctx).Do(); Trailers = new GetTrailers(_ctx).Do(); Trucks = new GetTrucks(_ctx).Do(); }
public async Task <List <GameTrailer> > GetTrailersByID(int GameID) { SqlParameter gameParam = new SqlParameter { ParameterName = "@GameID", SqlDbType = SqlDbType.Int, Value = GameID }; return(await GetTrailers.FromSql("Exec CoQ.GetTrailersByID @GameID", gameParam) .AsNoTracking() .ToListAsync()); }