public async Task <List <Trip> > GetTripsByRouteId(int routeId) { using (var conn = new SqlConnection(AppSettings.ConnectionString)) { var sql = new TripsSql(); var result = await conn.QueryAsync <Trip>(sql.TripsByRouteId(routeId)); return(result.ToList()); } }
public TripsRepository(ILogger logger) { _logger = logger; _sql = new TripsSql(); }