SQL

Entity framework connection string example

Entity framework connection string example, someone asked me to explain?

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:

Entity framework connection string example

Post your comments / questions