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

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

            coll.LoadAndCloseReader(qry.ExecuteReader());
            return(coll);
        }
        public FacOrdenPacienteCollection FetchByID(object IdOrdenPaciente)
        {
            FacOrdenPacienteCollection coll = new FacOrdenPacienteCollection().Where("idOrdenPaciente", IdOrdenPaciente).Load();

            return(coll);
        }