C# (CSharp) DBA_TAB_COMMENTS 예제들

예제 #1

파일: TableCommentGenerator.cs 프로젝트: radtek/DBScout

        private void LoadTabComments()
        {
            if (_table != null)
            {
                _tabComments = DbContext.DBA_TAB_COMMENTS
                               .FirstOrDefault(c => c.OWNER == _table.OWNER && c.TABLE_NAME == _table.TABLE_NAME);
            }

            if (_view != null)
            {
                _tabComments = DbContext.DBA_TAB_COMMENTS
                               .FirstOrDefault(c => c.OWNER == _view.OWNER && c.TABLE_NAME == _view.VIEW_NAME);
            }

            if (_mview != null)
            {
                _mviewComments = DbContext.DBA_MVIEW_COMMENTS
                                 .FirstOrDefault(c => c.OWNER == _mview.OWNER && c.MVIEW_NAME == _mview.MVIEW_NAME);
            }
        }

예제 #2

        private void LoadTabComments()
        {
            if (_table != null)
            {
                _tabComments = DbContext.DBA_TAB_COMMENTS
                    .FirstOrDefault(c => c.OWNER == _table.OWNER && c.TABLE_NAME == _table.TABLE_NAME);
            }

            if (_view != null)
            {
                _tabComments = DbContext.DBA_TAB_COMMENTS
                    .FirstOrDefault(c => c.OWNER == _view.OWNER && c.TABLE_NAME == _view.VIEW_NAME);
            }

            if (_mview != null)
            {
                _mviewComments = DbContext.DBA_MVIEW_COMMENTS
                    .FirstOrDefault(c => c.OWNER == _mview.OWNER && c.MVIEW_NAME == _mview.MVIEW_NAME);
            }
        }