C# (CSharp) DbTool.DbClasses OracleIndexClass Exemples

Exemple #1

        public List <IIndexClass> GetIndexs()
        {
            if (_indexs.Count == 0 && !_isLoadInds)
            {
                string    sql = "select * from user_indexes where index_type='NORMAL' and dropped='NO'";
                DataTable dt  = _oracleHelper.ExecuteDataTable(sql);
                foreach (DataRow item in dt.Rows)
                {
                    OracleIndexClass oic = new OracleIndexClass(item);
                    oic.SetOracleHelper(_oracleHelper);
                    _indexs.Add(oic);
                }
                _isLoadInds = true;
            }
            List <IIndexClass> t = new List <IIndexClass>();

            t.AddRange(_indexs);
            return(t);
        }

Exemple #2

Fichier : OracleConstraintClass.cs Projet : radtek/dbtool-1

 internal void DoLoadIndex()
 {
     if (!_isLoadIndex)
     {
         string type = Convert.ToString(constraint_type);
         if (type != "R")//不是外键
         {
             string indexName = Convert.ToString(index_name);
             if (_oracleHelper != null && !string.IsNullOrWhiteSpace(indexName) && oracleIndexClass == null)
             {
                 string    sql = "select * from user_indexes where index_type='NORMAL' and dropped='NO' and index_name='" + index_name + "'";
                 DataTable dt  = _oracleHelper.ExecuteDataTable(sql);
                 if (dt.Rows.Count > 0)
                 {
                     oracleIndexClass = new OracleIndexClass(dt.Rows[0]);
                 }
             }
         }
         _isLoadIndex = true;
     }
 }

Exemple #3

Fichier : OracleConstraintClass.cs Projet : leasange/dbtool

 internal void DoLoadIndex()
 {
     if (!_isLoadIndex)
     {
         string type = Convert.ToString(constraint_type);
         if (type != "R")//不是外键
         {
             string indexName = Convert.ToString(index_name);
             if (_oracleHelper != null && !string.IsNullOrWhiteSpace(indexName) && oracleIndexClass == null)
             {
                 string sql = "select * from user_indexes where index_type='NORMAL' and dropped='NO' and index_name='" + index_name + "'";
                 DataTable dt = _oracleHelper.ExecuteDataTable(sql);
                 if (dt.Rows.Count > 0)
                 {
                     oracleIndexClass = new OracleIndexClass(dt.Rows[0]);
                 }
             }
         }
         _isLoadIndex = true;
     }
 }

Exemple #4

Fichier : OracleDbClass.cs Projet : leasange/dbtool

 public List<IIndexClass> GetIndexs()
 {
     if (_indexs.Count == 0 && !_isLoadInds)
     {
         string sql = "select * from user_indexes where index_type='NORMAL' and dropped='NO'";
         DataTable dt = _oracleHelper.ExecuteDataTable(sql);
         foreach (DataRow item in dt.Rows)
         {
             OracleIndexClass oic = new OracleIndexClass(item);
             oic.SetOracleHelper(_oracleHelper);
             _indexs.Add(oic);
         }
         _isLoadInds = true;
     }
     List<IIndexClass> t = new List<IIndexClass>();
     t.AddRange(_indexs);
     return t;
 }