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

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

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

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

            return(coll);
        }