public List<DBCommand> GetCommands (int lane_id)
{
List<DBCommand> result = new List<DBCommand> ();
using (IDbCommand cmd = CreateCommand ()) {
cmd.CommandText = "SELECT * FROM Command ";
if (lane_id > 0) {
cmd.CommandText += "WHERE lane_id = @lane_id ";
DB.CreateParameter (cmd, "lane_id", lane_id);
}
cmd.CommandText += "ORDER BY sequence ASC";
using (IDataReader reader = cmd.ExecuteReader ()) {
while (reader.Read ())
result.Add (new DBCommand (reader));
}
}
return result;
}