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

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

            coll.LoadAndCloseReader(qry.ExecuteReader());
            return(coll);
        }
        public SysTipoObraSocialCollection FetchByID(object IdTipoObraSocial)
        {
            SysTipoObraSocialCollection coll = new SysTipoObraSocialCollection().Where("idTipoObraSocial", IdTipoObraSocial).Load();

            return(coll);
        }