public static List<Canal> SelectAll()
 {
     CanalDSTableAdapters.TblCanalTableAdapter adapter = new CanalDSTableAdapters.TblCanalTableAdapter();
     CanalDS.TblCanalDataTable table = adapter.SelectAll();
     List<Canal> listaCanals = new List<Canal>();
     foreach (CanalDS.TblCanalRow row in table)
     {
         Canal objCanal = RowToDto(row);
         listaCanals.Add(CargarInformacionCompleta(objCanal));
     }
     return listaCanals;
 }