在控制台应用中获取连接字符串 [英] Get connection string in console application

问题描述

我创建了一个控制台应用程序项目，然后将新的App.conf文件添加到我的项目中。在我的配置文件中，我复制了通过添加实体框架创建的连接字符串，如下所示：

 < connectionStrings> 
< add name =DBEntitiesconnectionString =metadata = res：//*/DBModel.csdl | res：//*/DBModel.ssdl | res：//*/DBModel.msl; provider = System .Data.SqlClient; provider connection string =& quot; Data Source = MY-LAPTOP; Initial Catalog = TestDB; User ID = test; Password = 123123; MultipleActiveResultSets = True& quot; providerName =System.Data.EntityClient/> 
< / connectionStrings> 
  

在program.cs上，我想使用ConfigurationManager类保留连接字符串，但总是会引起错误。

  String connString = ConfigurationManager.ConnectionStrings [ApplicationServices]。 
  

请给我建议我的解决方案。感谢提前。

解决方案

您的连接字符串称为 DBEntities p>

在代码中使用这一行：

  String connString = ConfigurationManager。的ConnectionStrings [ DBEntities]的ConnectionString。 
  

I've created an Console application project then add new App.conf file into my project. In my configuration file, I copied connection string that I've created by adding entity framework as below:

<connectionStrings>
    <add name="DBEntities" connectionString="metadata=res://*/DBModel.csdl|res://*/DBModel.ssdl|res://*/DBModel.msl;provider=System.Data.SqlClient;provider connection string=&quot;Data Source=MY-LAPTOP;Initial Catalog=TestDB;User ID=test;Password=123123;MultipleActiveResultSets=True&quot;" providerName="System.Data.EntityClient" />
  </connectionStrings>

On the program.cs I want to using ConfigurationManager class to retain the connection string but always raise me errors.

String connString = ConfigurationManager.ConnectionStrings["ApplicationServices"].ConnectionString;

Please suggest me solutions. Thanks in advance.

解决方案

Your connection string is called DBEntities

Use this line in your code instead:

String connString = ConfigurationManager.ConnectionStrings["DBEntities"].ConnectionString;

这篇关于在控制台应用中获取连接字符串的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！