CODEWITHSUNDEEP
.netentity-frameworkado.netconnection-string
Flavio CF Oliveira
Flavio CF Oliveira

Reputation: 5295

How to get provider specific ConnectionString from Entity Framework

using ado.net tipically we need to define a connectionstring to create a sqlconnection object, and if we use the entity framework, we have to dedine a connectionstring too.

is threre any way to get the specific provider connectionstring used by entity framework?

Assuming that originally on ado.net we define the CS like:

"Data Source=myServerAddress;Initial Catalog=myDataBase;User Id=myUsername;Password=myPassword;"

and Entityframework should translate their CS format on something like that, is it possible to obtain this?

what i pretend is to know if is possible to get the specific provider connectionstring generated by EF?

How can i convert a entityframework connectionstring on a sqlserver connectionstring?

Upvotes: 14

Views: 6935

Answers (2)

Flavio CF Oliveira
Flavio CF Oliveira

Reputation: 5295

Found the solution:

            System.Data.EntityClient.EntityConnection c = (System.Data.EntityClient.EntityConnection)EFDBcontext.Connection;
            String S = c.StoreConnection.ConnectionString;

Upvotes: 4

Thomas Levesque
Thomas Levesque

Reputation: 292695

string entityConnectionString = ...

var builder = new EntityConnectionStringBuilder(entityConnectionString);
string providerConnectionString = builder.ProviderConnectionString;

Upvotes: 31

Related Questions