public EmpresaBEList GetListaEmpresa() { EmpresaBEList lista = new EmpresaBEList(); IDataReader DReader = null; try { using (Database db = new Database()) { db.ProcedureName = "sgsnet_sps_listado_empresa"; DReader = db.GetDataReader(); } while (DReader.Read()) { lista.Add(CrearEntidadLista(DReader)); } DReader.Close(); } catch { if (DReader != null && !DReader.IsClosed) { DReader.Close(); } throw; } return(lista); }