取出dataConfiguration.config里的数据,查询数据库中表的所有信息(如是否是主健等)

本文链接：https://blog.youkuaiyun.com/hufengwen/article/details/1389570

本文介绍如何读取dataConfiguration.config文件的内容，并利用这些数据查询SQL Server数据库中表的详细信息，包括主键等元数据。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

1.取出dataConfiguration.config里的数据,查询数据库中表的所有信息(如是否是主健等)

DatabaseSettings databaseSettings = ConfigurationManager.GetConfiguration("dataConfiguration") as DatabaseSettings;
            string dataBase = this.generateRule_ddl_Database.SelectedValue;
            if(databaseSettings.Instances[dataBase].DatabaseTypeName =="Sql Server")
            {
                ViewState["AlertRuleOorS"] = "0";
            }
            else
            {
                ViewState["AlertRuleOorS"] = "1";
            }
            string connectString = databaseSettings.Instances[dataBase].ConnectionString;
            ConnectionStringData connectionStringData = databaseSettings.ConnectionStrings[connectString];
            bool isPrimaryKey = false;
            foreach( ParameterData parameter in connectionStringData.Parameters )
            {
                switch( parameter.Name.ToLower() )
                {
                    case "database":
                        ViewState["database"] = parameter.Value;
                        break;
                    case "integrated security":
                        ViewState["Security"] = parameter.Value;
                        break;
                    case "server":
                        ViewState["server"] = parameter.Value;
                        break;
                    case "user id":
                        ViewState["userID"] = parameter.Value;
                        break;
                    case "password":
                        ViewState["password"] = parameter.Value;
                        break;
                    case "data source":
                        ViewState["dataSource"] = parameter.Value;
                        break;
                }
            }
            DataConfiguration    config;
            if(ViewState["AlertRuleOorS"].ToString() == "0")
            {
                config = new DataConfiguration(DataBaseType.SqlServer ,ViewState["server"].ToString(),
                    ViewState["userID"].ToString() ,ViewState["password"].ToString() ,ViewState["database"].ToString() ,null);
            }
            else
            {
                config = new DataConfiguration(DataBaseType.Oracle,null,ViewState["userID"].ToString(),
                    ViewState["password"].ToString() ,null,ViewState["dataSource"].ToString());
            }

            IADOBase ado = ADOBaseFactory.CreateADOBase(config) ;
            string table = "";
            if(ViewState["generateRuleWay"] as string == "Script")
            {
                string[] sql = splitSQL(generateRule_txt_Rule.Text.ToString());
                if(sql[1].IndexOf(',')!=-1)
                {
                    LogicException le = new LogicException("MaintainAlert+BAS00057");
                    JscriptHelper.Alert(le);
                }
                table = sql[1].Trim();
            }
            else
            {
                table = this.generateRule_ddl_Table.SelectedValue.Trim();
            }
            DataSchema schema = ado.DataSchemaOperator.GetDataSchema(table);
            StringBuilder primaryKey = new StringBuilder();
            int count = schema.PKeyList.Count;
            if(count != 0)
            {
                for(int n = 0;n<count;n++)
                {
                    isPrimaryKey = true;
                    primaryKey.Append(schema.PKeyList[n]);
                    primaryKey.Append(",");
                }
                primaryKey.Remove(primaryKey.Length-1,1);
                Session["primaryKey"] = primaryKey;
            }
            if(!isPrimaryKey)
            {
                LogicException le = new LogicException("MaintainAlert+BAS00054");
                JscriptHelper.Alert(le);
                this.generateRule_btn_PrimaryKey.Visible = true;
                this.generateRule_lbl_PrimaryKey.Visible = true;
            }
            ViewState["check"] = "Y";

2.dataConfiguration.config