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="data source......;MultipleActiveResultSets=True;App=EntityFramework"" 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:
Post your comments / questions
Recent Article
- ValueError:All arrays must be of the same length - Python
- Check hostname requires server hostname - SOLVED
- How to restrict access to the page Access only for logged user in Django
- Migration admin.0001_initial is applied before its dependency admin.0001_initial on database default
- Add or change a related_name argument to the definition for 'auth.User.groups' or 'DriverUser.groups'. -Django ERROR
- Addition of two numbers in django python
- The request was aborted: Could not create SSL/TLS secure channel -Error in Asp.net
- FieldError: Cannot resolve keyword 'id' into field in Django project
Related Article