public ConConsultaDiagnosticoCollection FetchByQuery(Query qry)
        {
            ConConsultaDiagnosticoCollection coll = new ConConsultaDiagnosticoCollection();

            coll.LoadAndCloseReader(qry.ExecuteReader());
            return(coll);
        }
        public ConConsultaDiagnosticoCollection FetchAll()
        {
            ConConsultaDiagnosticoCollection coll = new ConConsultaDiagnosticoCollection();
            Query qry = new Query(ConConsultaDiagnostico.Schema);

            coll.LoadAndCloseReader(qry.ExecuteReader());
            return(coll);
        }