Пример #1
0
        public List <string> GetTableNames()
        {
            var ret = new List <string>();
            DbStructInterface si     = Dialect.GetDbStructInterface();
            string            userId = Dialect.GetUserId(Driver.ConnectionString);

            DbEntry.UsingConnection(() => {
                using (var c = (DbConnection)(Scope <ConnectionContext> .Current.GetConnection(this)))
                {
                    var t = c.GetSchema(si.TablesTypeName, si.TablesParams);
                    foreach (DataRow dr in t.Rows)
                    {
                        if (si.FiltrateDatabaseName)
                        {
                            if (!dr["TABLE_SCHEMA"].Equals(c.Database))
                            {
                                continue;
                            }
                        }
                        if (userId != null)
                        {
                            if (!dr["OWNER"].Equals(userId))
                            {
                                continue;
                            }
                        }
                        string s = dr[si.TableNameString].ToString();
                        ret.Add(s);
                    }
                }
            });
            return(ret);
        }
Пример #2
0
        public List <string> GetTableNames()
        {
            var ret = new List <string>();
            DbStructInterface si     = Dialect.GetDbStructInterface();
            string            userId = Dialect.GetUserId(ConnectionString);

            using (var c = (DbConnection)GetDbConnection())
            {
                c.Open();
                foreach (DataRow dr in c.GetSchema(si.TablesTypeName, si.TablesParams).Rows)
                {
                    if (si.FiltrateDatabaseName)
                    {
                        if (!dr["TABLE_SCHEMA"].Equals(c.Database))
                        {
                            continue;
                        }
                    }
                    if (userId != null)
                    {
                        if (!dr["OWNER"].Equals(userId))
                        {
                            continue;
                        }
                    }
                    string s = dr[si.TableNameString].ToString();
                    ret.Add(s);
                }
            }
            return(ret);
        }