public List<DBHost> GetHostsForLane (int lane_id)
{
List<DBHost> result = new List<DBHost> ();
using (IDbCommand cmd = CreateCommand ()) {
cmd.CommandText = "SELECT *, HostLane.lane_id AS lane_id FROM Host INNER JOIN HostLane ON Host.id = HostLane.host_id WHERE lane_id = @lane_id";
DB.CreateParameter (cmd, "lane_id", lane_id);
using (IDataReader reader = cmd.ExecuteReader ()) {
while (reader.Read ()) {
result.Add (new DBHost (reader));
}
}
}
return result;
}