Build Entity connection string from ADO.NET

Question

In my web site I have regular ADO.NET connection string like: ,

now Entity Framework added it's own connection string to same database.

How is it possible to use only one ADO.NET connection string and build Entity Connection string in runtime?

I belive entity connection string adds metadata to connection string therefore not sure if you can use ADO.NET as Entity Connection string — COLD TOLD
– COLD TOLD, Commented Dec 2, 2012 at 23:04
I need take data from ADO.NET and bind Entity connection string, based on ADO.NET — ihorko
– ihorko, Commented Dec 2, 2012 at 23:16

COLD TOLD · Accepted Answer · 2012-12-02 23:08:15Z

3

you can use EntityConnectionStringBuilder to generate connection string at runtime dynamically at runtime but you still need metada for this

EntityConnectionStringBuilder entityBuilder =
    new EntityConnectionStringBuilder();
    //Set the provider name.
    entityBuilder.Provider = providerName;

    // Set the provider-specific connection string.
    entityBuilder.ProviderConnectionString = providerString;

    // Set the Metadata location.
    entityBuilder.Metadata = @"res://*/AdventureWorksModel.csdl|
                                res://*/AdventureWorksModel.ssdl|
                                res://*/AdventureWorksModel.msl";
using (EntityConnection conn =
    new EntityConnection(entityBuilder.ToString()))
{
    conn.Open();
    Console.WriteLine("Just testing the connection.");
    conn.Close();
}

answered Dec 2, 2012 at 23:08

COLD TOLD

13.6k3 gold badges37 silver badges53 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

ihorko Over a year ago

How can I build this Entity connection string based on ADO.NET connection string?

COLD TOLD Over a year ago

the connection string is still just a connection string you just need to have Provider, ProviderConnectionString like user info and so on and Metadata you can get by manually creating EF connection string and the copy that metadata to you entityBuilder.Metadata at runtime

Collectives™ on Stack Overflow

Build Entity connection string from ADO.NET

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related