public IQueryable <TableBookingTime> FindAll() { List <TableBookingTime> times = new List <TableBookingTime>(); string sql = "SELECT RowID, TimeValue, TimeText, Season, TimeOrder " + "FROM [AP_TableBookingTime]"; SqlDataReader sdr = SqlHelper.ExecuteReader(_connection, CommandType.Text, sql); while (sdr.Read()) { TableBookingTime time = new TableBookingTime(new Guid(sdr["RowID"].ToString()), sdr["TimeValue"].ToString(), sdr["TimeText"].ToString(), sdr["Season"].ToString(), Convert.ToInt32(sdr["TimeOrder"])); times.Add(time); } sdr.Close(); return(times.AsQueryable()); }
public void Save(TableBookingTime aggregateRoot) { throw new NotImplementedException(); }