public static Canal Select(int id)
    {
        CanalDSTableAdapters.CanalTableAdapter adapter = new CanalDSTableAdapters.CanalTableAdapter();
        CanalDS.CanalDataTable table = adapter.Select(id);

        Canal objCanal = rowToDto(table[0]);

        return objCanal;
    }
 public static List<Canal> SelectSuscritos(int id)
 {
     CanalDSTableAdapters.CanalTableAdapter adapter = new CanalDSTableAdapters.CanalTableAdapter();
     CanalDS.CanalDataTable table = adapter.SelectSuscritos(id);
     List<Canal> listaDeCanals = new List<Canal>();
     foreach (CanalDS.CanalRow row in table)
     {
         listaDeCanals.Add(rowToDto(row));
     }
     return listaDeCanals;
 }
 public static void Update(string nombre, string imagen, DateTime creacion, int usuario, int id)
 {
     CanalDSTableAdapters.CanalTableAdapter adapter = new CanalDSTableAdapters.CanalTableAdapter();
     adapter.Update(nombre, imagen, creacion, usuario, id);
 }
 public static object Insert(string nombre, string imagen, DateTime creacion, int usuario)
 {
     CanalDSTableAdapters.CanalTableAdapter adapter = new CanalDSTableAdapters.CanalTableAdapter();
     object id = adapter.Insert1(nombre, imagen, creacion, usuario);
     return id;
 }
 public static void Delete(int id)
 {
     CanalDSTableAdapters.CanalTableAdapter adapter = new CanalDSTableAdapters.CanalTableAdapter();
     adapter.Delete(id);
 }