public List<TableOrViewInfo> ReadAllTableAndViewInfo(string connString)
        {
            // 预期结果.
            List<TableOrViewInfo> resultList = new List<TableOrViewInfo>();


            using (OracleConnection conn = new OracleConnection(connString))
            {
                // 创建DataSet,用于存储数据.
                DataSet resultDataSet = new DataSet();

                // 创建一个适配器
                OracleDataAdapter tableAdapter = new OracleDataAdapter(READ_TABLE_INFO_SQL, conn);
                // 执行查询,并将数据导入DataSet.
                tableAdapter.Fill(resultDataSet, "TableInfo");

                // 创建一个适配器
                OracleDataAdapter tableColumnAdapter = new OracleDataAdapter(READ_TABLE_COLUMN_INFO_SQL, conn);
                // 执行查询,并将数据导入DataSet.
                tableColumnAdapter.Fill(resultDataSet, "TableColumnInfo");




                #region  先加表.

                foreach (DataRow tableRow in resultDataSet.Tables["TableInfo"].Rows)
                {
                    // 依次处理每一个表.
                    TableOrViewInfo tableInfo = new TableOrViewInfo();

                    // 表.
                    tableInfo.IsView = false;
                    // 表名.
                    tableInfo.Name = tableRow["TABLE_NAME"].ToString();
                    // 备注.
                    tableInfo.Comment = tableRow["COMMENTS"].ToString();

                    // 列.
                    tableInfo.ColumnList = new List<ColumnInfo>();


                    // 检索当前表的列.
                    DataRow[] rows = resultDataSet.Tables["TableColumnInfo"].Select("TABLE_NAME='" + tableInfo.Name + "'");

                    for (int i = 0; i < rows.Length; i++)
                    {
                        DataRow row = rows[i];
                        // 读取每一列.
                        ColumnInfo columnInfo = new ColumnInfo();
                        // 列名
                        columnInfo.Name = row["COLUMN_NAME"].ToString();
                        // 备注/说明信息
                        columnInfo.Comment = row["COMMENTS"].ToString();


                        // 列加入表的列List.
                        tableInfo.ColumnList.Add(columnInfo);
                    }

                    // 处理完毕后,表加入结果列表.
                    resultList.Add(tableInfo);
                }

                #endregion


            }


            return resultList;
        }
        public List<TableOrViewInfo> ReadAllTableAndViewInfo(string connString)
        {
            // 预期结果.
            List<TableOrViewInfo> resultList = new List<TableOrViewInfo>();


            // 建立数据库连接.
            SqlConnection conn = new SqlConnection(connString);




            // 创建DataSet,用于存储数据.
            DataSet resultDataSet = new DataSet();

            // 创建一个适配器
            SqlDataAdapter tableAdapter = new SqlDataAdapter(READ_TABLE_INFO_SQL, conn);
            // 执行查询,并将数据导入DataSet.
            tableAdapter.Fill(resultDataSet, "TableInfo");

            // 创建一个适配器
            SqlDataAdapter tableColumnAdapter = new SqlDataAdapter(READ_TABLE_COLUMN_INFO_SQL, conn);
            // 执行查询,并将数据导入DataSet.
            tableColumnAdapter.Fill(resultDataSet, "TableColumnInfo");


            // 创建一个适配器
            SqlDataAdapter viewAdapter = new SqlDataAdapter(READ_VIEW_INFO_SQL, conn);
            // 执行查询,并将数据导入DataSet.
            viewAdapter.Fill(resultDataSet, "ViewInfo");

            // 创建一个适配器
            SqlDataAdapter viewColumnAdapter = new SqlDataAdapter(READ_VIEW_COLUMN_INFO_SQL, conn);
            // 执行查询,并将数据导入DataSet.
            viewColumnAdapter.Fill(resultDataSet, "ViewColumnInfo");




            #region  先加表.

            foreach (DataRow tableRow in resultDataSet.Tables["TableInfo"].Rows)
            {
                // 依次处理每一个表.
                TableOrViewInfo tableInfo = new TableOrViewInfo();

                // 表.
                tableInfo.IsView = false;
                // 表名.
                tableInfo.Name = tableRow["TableName"].ToString();
                // 备注.
                tableInfo.Comment = tableRow["Comment"].ToString();

                // 列.
                tableInfo.ColumnList = new List<ColumnInfo>();


                // 检索当前表的列.
                DataRow[] rows = resultDataSet.Tables["TableColumnInfo"].Select("TableName='" + tableInfo.Name + "'", "ColumnId");

                for (int i = 0; i < rows.Length; i++)
                {
                    DataRow row = rows[i];
                    // 读取每一列.
                    ColumnInfo columnInfo = new ColumnInfo();
                    // 列名
                    columnInfo.Name = row["ColumnName"].ToString();
                    //// 列的顺序
                    //columnInfo.ColumnId = Convert.ToInt32(row["ColumnId"]);
                    //// 数据类型
                    //columnInfo.DataType = row["DataType"].ToString();
                    //// 占用字节数
                    //columnInfo.MaxLength = Convert.ToInt32(row["MaxLength"]);
                    //// 长度
                    //columnInfo.Precision = Convert.ToInt32(row["Precision"]);
                    //// 小数位数
                    //columnInfo.Scale = Convert.ToInt32(row["Scale"]);
                    //// 是否允许非空
                    //columnInfo.IsNullAble = Convert.ToInt32(row["IsNullAble"]) == 1;
                    //// 是否是自增ID
                    //columnInfo.IsIDEntity = Convert.ToInt32(row["IsIDEntity"]) == 1;
                    //// 是否是主键
                    //columnInfo.IsPrimaryKey = Convert.ToInt32(row["IsPrimaryKey"]) == 1;
                    // 备注/说明信息
                    columnInfo.Comment = row["Comment"].ToString();


                    // 列加入表的列List.
                    tableInfo.ColumnList.Add(columnInfo);
                }

                // 处理完毕后,表加入结果列表.
                resultList.Add(tableInfo);
            }

            #endregion



            #region 后处理视图.


            foreach (DataRow viewRow in resultDataSet.Tables["ViewInfo"].Rows)
            {
                // 依次处理每一个视图.
                TableOrViewInfo viewInfo = new TableOrViewInfo();

                // 视图.
                viewInfo.IsView = true;
                // 视图名.
                viewInfo.Name = viewRow["ViewName"].ToString();
                // 备注.
                viewInfo.Comment = viewRow["Comment"].ToString();

                // 列.
                viewInfo.ColumnList = new List<ColumnInfo>();

                // 检索当前表的列.
                DataRow[] rows = resultDataSet.Tables["ViewColumnInfo"].Select("ViewName='" + viewInfo.Name + "'", "ColumnId");


                for (int i = 0; i < rows.Length; i++)
                {
                    DataRow row = rows[i];
                    // 读取每一列.
                    ColumnInfo columnInfo = new ColumnInfo();
                    // 列名
                    columnInfo.Name = row["ColumnName"].ToString();
                    //// 列的顺序
                    //columnInfo.ColumnId = Convert.ToInt32(row["ColumnId"]);
                    //// 数据类型
                    //columnInfo.DataType = row["DataType"].ToString();
                    //// 占用字节数
                    //columnInfo.MaxLength = Convert.ToInt32(row["MaxLength"]);
                    //// 长度
                    //columnInfo.Precision = Convert.ToInt32(row["Precision"]);
                    //// 小数位数
                    //columnInfo.Scale = Convert.ToInt32(row["Scale"]);
                    //// 是否允许非空
                    //columnInfo.IsNullAble = Convert.ToInt32(row["IsNullAble"]) == 1;
                    //// 是否是自增ID
                    //columnInfo.IsIDEntity = Convert.ToInt32(row["IsIDEntity"]) == 1;
                    //// 是否是主键
                    //columnInfo.IsPrimaryKey = Convert.ToInt32(row["IsPrimaryKey"]) == 1;
                    // 备注/说明信息
                    columnInfo.Comment = row["Comment"].ToString();


                    // 列加入 视图的列List.
                    viewInfo.ColumnList.Add(columnInfo);
                }



                // 处理完毕后,加入结果列表.
                resultList.Add(viewInfo);
            }



            #endregion




            return resultList;
        }