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