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

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

            coll.LoadAndCloseReader(qry.ExecuteReader());
            return(coll);
        }
        public PnSmitiposcategoriaCollection FetchByID(object Codcategoria)
        {
            PnSmitiposcategoriaCollection coll = new PnSmitiposcategoriaCollection().Where("codcategoria", Codcategoria).Load();

            return(coll);
        }