public CompendioGeneral get(int id_compendio) { using (var dbContextTransaction = context.Database.BeginTransaction()) { try { List <CompendioGeneral> objLista = new List <CompendioGeneral>(); DataSet dataSet = MGR_Common.OracleHelper.Query(conn, MgrEnumConsultaGeneral.obtenerCompendioGeneral(id_compendio), System.Data.CommandType.Text, null); if (dataSet != null) { objLista = dataSet.Tables[0].DataTableToList <CompendioGeneral>(); return(objLista[0]); } } catch (Exception ext) { string valor = ext.ToString(); dbContextTransaction.Rollback(); } return(null); } }