c# .net Adsense ADO.NET Linq Viruses/security asp.net MVC JQuery Angular-js Node-js SEO Java C++ SQL API Networking vb.net .Net Css JavaScript Generics c#.Net entity framework HTML Website host Website Construction Guide HTTP tutorial W3C tutorial Web Services JSON Psychology Ionic framework Angular ReactJS Python Computer Android
SQL

Entity framework connection string example

| | CSharp , webconfig

To get the SQL connection string from entity framework using DbConetext edmx file. In this example I will show you with example.

The connection String element must be present in the web.config with specified name.

Example Connection String:

<add name="models" connectionString="metadata=res://*/Models.mydb.csdl|res://*/Models.mydb.ssdl|res://*/Models.mydb.msl;provider=System.Data.SqlClient;providerconnection string=&quot;data source......;MultipleActiveResultSets=True;App=EntityFramework&quot;" providerName="System.Data.EntityClient" />

Solution:

You must get the connection string that used by Entity framework by using the following way.

dbContext db = new dbContext();string connstring = db.Database.Connection.ConnectionString;

Output: