public List <Specialty> GetSpecialties(string orderBy = "id", string order = "ASC") { List <Specialty> specialties = new List <Specialty>() { }; DB.OpenConnection(); DB.SetCommand(@"SELECT * FROM " + _tableRelational + " WHERE stylistId=@thisId ORDER BY " + orderBy + " " + order + ";"); DB.AddParameter("@thisId", _id); MySqlDataReader rdr = DB.ReadSqlCommand(); while (rdr.Read()) { Specialty newSpeciality = Specialty.Find(rdr.GetInt32(1)); specialties.Add(newSpeciality); } DB.CloseConnection(); return(specialties); }