Beispiel #1
0
        public static DataTable RecuperarTodosEstudios()
        {
            DataTable tablaEstudios = new DataTable();

            tablaEstudios.Columns.Add("codigoEstudio");
            tablaEstudios.Columns.Add("descripcionEstudio");

            ISession nhSesion = ManejoNHibernate.IniciarSesion();

            try
            {
                List <Estudio> listaEstudios = CatalogoEstudio.RecuperarTodos(nhSesion);
                tablaEstudios = (from p in listaEstudios select p).Aggregate(tablaEstudios, (dt, r) => { dt.Rows.Add(r.Codigo, r.Descripcion); return(dt); });
            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
                nhSesion.Close();
                nhSesion.Dispose();
            }

            return(tablaEstudios);
        }