コード例 #1
0
ファイル: Sql.cs プロジェクト: albinvinoy/OneConnect
        public Dictionary <string, List <string> > getTableData()
        {
            DataTable tables = null;

            if (connectionOpen)
            {
                tables = connection.GetSchema("Tables");
                foreach (DataRow name in tables.Rows)
                {
                    ParseSchema ps = new ParseSchema();
                    ps.parseSchema((string)name[6]);
                    databaseSchema.Add((string)name[2], ps.getSchema);
                }
            }
            return(databaseSchema);
        }
コード例 #2
0
        public Dictionary <string, List <string> > getTableData()
        {
            DataTable tables = null;

            string[] restrictions = new string[4];
            if (connectionOpen)
            {
                tables = connection.GetSchema("Tables");

                foreach (DataRow name in tables.Rows)
                {
                    restrictions[2] = name.ItemArray[2].ToString();
                    DataTable   table = connection.GetSchema("Columns", restrictions);
                    ParseSchema ps    = new ParseSchema();
                    ps.parseSchema((string)name[6]);
                    databaseSchema.Add(name.ItemArray[2].ToString(), ps.getSchema);
                }
            }
            return(databaseSchema);
        }