public LPatientInfoDeletedCollection FetchByQuery(Query qry)
        {
            var coll = new LPatientInfoDeletedCollection();

            coll.LoadAndCloseReader(qry.ExecuteReader());
            return(coll);
        }
        public LPatientInfoDeletedCollection FetchAll()
        {
            var coll = new LPatientInfoDeletedCollection();
            var qry  = new Query(LPatientInfoDeleted.Schema);

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

            return(coll);
        }