private static void LoadInfoForFish(Fish fish) { var sql = String.Format("select info from fishinfo where fish = {0} order by infoid;", fish.ToDTO().Id.ToString()); var infoResultSet = ConnectionUtils.ExecuteCommand(new PostgreSQLConnection(), sql); for (var i = 0; i < infoResultSet[0].Count; i++) { fish.AddInfo(infoResultSet[0][i]); } }