新手问题APP.CONFIG

Question

app.config 清单
<?xml version="1.0" encoding="utf-8"?>
<configuration>
  <configSections>
    <section name="dataConfiguration" type="Microsoft.Practices.EnterpriseLibrary.Data.Configuration.DatabaseSettings, Microsoft.Practices.EnterpriseLibrary.Data, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" />
  </configSections>
  <dataConfiguration defaultDatabase="BaccoSDB String" />
  <connectionStrings>
    <add name="BaccoSDB String" connectionString="Database=BaccoS;Server=(local)\SQLEXPRESS;uid=sa;pwd=000000"
      providerName="System.Data.SqlClient" />
  </connectionStrings>
</configuration>
调用
Database test = DatabaseFactory.CreateDatabase("BaccoSDB String");
错误
异常详细信息: System.Configuration.ConfigurationErrorsException: The requested database TobaccoSDB String is not defined in configuration.
刚接触，还望大家帮帮忙！~谢谢~！

Answer 1

TobaccoSDB String 哪来的？

Answer 2

异常详细信息: System.Configuration.ConfigurationErrorsException: The requested database BaccoSDB String is not defined in configuration.
原来Name = TobaccoSDB

Answer 3

Database test = DatabaseFactory.CreateDatabase(ConfigurationManager.ConnectionStrings["BaccoSDB String"].ConnectionString);

Answer 4

异常详细信息: System.NullReferenceException: 未将对象引用设置到对象的实例。调用：           Database test = DatabaseFactory.CreateDatabase(ConfigurationManager.ConnectionStrings["TobaccoSDB String"].ConnectionString);
           DbCommand dbCommand = test.GetStoredProcCommand("GetProductsByCategory");
           test.AddInParameter(dbCommand, "Code", DbType.String, "7");
           DataSet productDataSet = test.ExecuteDataSet(dbCommand); 

Answer 5

我都迷糊了~!
从新说一下现状吧~！
app.config 清单
<?xml version="1.0" encoding="utf-8"?>
<configuration>
  <configSections>
  <section name="dataConfiguration" type="Microsoft.Practices.EnterpriseLibrary.Data.Configuration.DatabaseSettings, Microsoft.Practices.EnterpriseLibrary.Data, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" />
  </configSections>
  <dataConfiguration defaultDatabase="BaccoSDB String" />
  <connectionStrings>
  <add name="BaccoSDB String" connectionString="Database=BaccoS;Server=(local)\SQLEXPRESS;uid=sa;pwd=000000"
  providerName="System.Data.SqlClient" />
  </connectionStrings>
</configuration>
调用
Database test = DatabaseFactory.CreateDatabase("BaccoSDB String");
错误
异常详细信息: System.Configuration.ConfigurationErrorsException: The requested database BaccoSDB String is not defined in configuration.按四楼的方法改成Database test = DatabaseFactory.CreateDatabase(ConfigurationManager.ConnectionStrings["BaccoSDB String"].ConnectionString);
错误信息：
异常详细信息: System.NullReferenceException: 未将对象引用设置到对象的实例。我真的不明白了~！
大家帮帮我~！

Answer 6

IConfigurationSource source = new FileConfigurationSource(@"配置文件位置");//配置文件位置
DatabaseProviderFactory factory = new DatabaseProviderFactory(source);Database db = factory.Create("BaccoSDB String"); //配置字符串

Answer 7

IConfigurationSource source = new FileConfigurationSource(@"配置文件位置");//配置文件位置
DatabaseProviderFactory factory = new DatabaseProviderFactory(source);
写到哪个文件里啊~！