MonkeyWrench.DB.GetHostsForLane C# (CSharp) Method

		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;
		}