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

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

            // Begin Bayshore custom code block (rread 6/26/07)
            // Ignore records marked for deletion when doing a FetchAll
            if (MasterDetailComment.Schema.GetColumn("IsDeleted") != null)
            {
                qry.WHERE("IsDeleted <> true");
            }
            else if (MasterDetailComment.Schema.GetColumn("Deleted") != null)
            {
                qry.WHERE("Deleted <> true");
            }
            // End Bayshore custom code block

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

            return(coll);
        }