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

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

            coll.LoadAndCloseReader(qry.ExecuteReader());
            return(coll);
        }
        public PnExpedienteCollection FetchByID(object IdExpediente)
        {
            PnExpedienteCollection coll = new PnExpedienteCollection().Where("id_expediente", IdExpediente).Load();

            return(coll);
        }