从App.config获取连接字符串 [英] Get connection string from App.config

问题描述

  var connection = ConnectionFactory.GetConnection（
 ConfigurationManager.ConnectionStrings [Test] 
 .ConnectionString，DataBaseProvider）; 
  

这是我的App.config：

< pre class =lang-xml prettyprint-override> <？xml version =1.0encoding =utf-8？>
< configuration>
< connectionStrings>
< add name =TestconnectionString =Data Source =; Initial Catalog = OmidPayamak; Integrated Security = TrueproviderName =System.Data.SqlClient/>
< / connectionStrings>
< / configuration>


但是当我的项目运行这是我的错误：

对象引用未设置为对象的实例。

解决方案

您不能只执行以下操作：

  var connection = 
 System.Configuration.ConfigurationManager 。 
 ConnectionStrings [Test]。ConnectionString; 
  

您的程序集还需要引用 System.Configuration.dll

var connection = ConnectionFactory.GetConnection(
    ConfigurationManager.ConnectionStrings["Test"]
    .ConnectionString, DataBaseProvider);

And this is my App.config:

<?xml version="1.0" encoding="utf-8" ?>
<configuration>
    <connectionStrings>
        <add name="Test" connectionString="Data Source=.;Initial Catalog=OmidPayamak;Integrated Security=True" providerName="System.Data.SqlClient" />
    </connectionStrings>
</configuration>

But when my project runs this is my error:

Object reference not set to an instance of an object.

解决方案

Can't you just do the following:

var connection = 
    System.Configuration.ConfigurationManager.
    ConnectionStrings["Test"].ConnectionString;

Your assembly also needs a reference to System.Configuration.dll

这篇关于从App.config获取连接字符串的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！