Get connection string in console application

.net entity-framework

Question

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.

1
16
5/16/2011 7:22:00 AM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Accepted Answer

Your connection string is called DBEntities

Use this line in your code instead:

String connString = ConfigurationManager.ConnectionStrings["DBEntities"].ConnectionString;
26
3/19/2013 3:38:39 PM

Popular Answer

This is only a guess since you didn't include the actual exception in your question:

Add a reference to System.Configuration to your project.

jgauffin

Related Questions

No connection string named 'MyEntities' could be found in the application config file

Try copying the connections string to the .config file in the MVC project.
asp.net-mvc-4 c# entity-framework
asked by Jerry

The connection string 'MyConnection' in the application's configuration file does not contain the required providerName attribute."

You're missing the following piece of code after the ...connectionString... attribute (assuming that you're using SQL):...providerName="System.Data.SqlClient"
connection-string ef-code-first entity-framework
asked by Corey Adler

No connection string named 'MyEntities' could be found in the application config file

Try copying the connections string to the .config file in the MVC project.
asp.net-mvc-4 c# entity-framework
asked by Jerry

How do I set a default connection string in a console application?

App.config is the equivalent to a Web.config for console or .exe programs....Add a reference to System.Configuration on any project that you want to use the ...ConnectionStrings... of the app.config...Add a AppConfig to your ...entry point... project. This is the project that is executed. (e.g. console .exe)...Add the connection string in the ...
c# entity-framework
asked by T McKeown

No connection string named "NorthwindConnection" could be found in the application config file

I have 2 projects: Console app and dll. In dll i am using EntityFramework. I have this app.config file:...<?xml version="1.0" encoding="utf-8"?> <configuration> <configSections> <!-- For more information on Entity Framework configuration, visit http://go.microsoft.com/fwlink/?LinkID=237468 --> <section name="entityFramework" t...
c# entity-framework
asked by BJladu4

How to define DataDirectory for ConnectionString in console application to work with EntityFramework Code First Migrations

Problem 1 (of 2)...When you set the value of ...DataDirectory..., it needs to be a directory, not a file. You are passing in the value of the ...absolute... variable which is:...C:\Users\s8359_000\Documents\Visual Studio 2013\Projects\Projekt5 — kopia\Projekt5\App_Data\Cos.mdf ...and which contains the filename. That is not valid. ...DataDirector...
app-config c# datadirectory entity-framework localdb
asked by Solomon Rutzky

No connection string found in App config using external Start-up application

So what I would do in this case is make a new Context which inherits from your current context and in the constructor pass in the connection string. ...Alternatively you can also create a connection string that you can then pass into the constructors overload for your context....public string GetConnectionString() { string connectionStr...
.net c# dll entity-framework-6
asked by IdahoSixString

No connection string named could be found in the application config file

You say "within my DAL, I have a webConfig". I guess the connection string is in the configuration file of a referenced class library, but not in the main configuration file you have in your entry project (a web api project, I guess looking at the tags)....If so, just copy the connection string in the entry project configuration file.
asp.net-web-api c# entity-framework
asked by Paolo Costa

Connection String in Unit Test App.Config is ignored: SQLExpress gets set to LocalDB

After diving through the code for a few days, I noticed that in one older library referenced by every class tested by every failing test, there was a data update written as:...dc.SubmitChanges(); ...and it hit me, this class was using LINQ to Sql instead of Entity Framework. Somehow the class using LINQ to Sql was altering the connection string and...
c# entity-framework-6 unit-testing
asked by dylanT

Getting database connection string in ASP.NET 5/EF 6

You have a couple of fairly easy options:...1: Start using Entity Framework 7. ...It's release schedule is timed in coordination with Asp.net 5, some features may be missing for awhile though...You would then use the AddDbContext as you've already tried...2: You can pass the entire connection string to the constructor/base upon context creation, us...
asp.net asp.net-core configuration entity-framework entity-framework-6
asked by developer

No connection string named 'x' found in application config file... but it works?

You're declaring an instance of your view model in the view. That results in VS instantiating your class within the editor, which in turn runs your constructor code within the VS process....Your constructor is attempting to connect to a database. It's looking for a connection string in the app.config file for the currently running process. The c...
c# entity-framework-6 mvvm wpf xaml
asked by user1228

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge
View more on Stack Overflow

Prime Library

Performance

Expression Evaluator

More Projects...

Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow