how to change the connection string in the EntityFramework ?

Question

4.67/5 (2 votes)

See more:

, +

Hi all
i make an entity framework for a database (sql) and another one for Oracle using third party. but to the same db schema and all my changing in the SSDL.schema and adding a new connection string in Web.config
and the entity.design.cs shared for both database (100% success when i change the connection string by hand in the code ). all what i need to change the connection in this file in the run time . is there a way to make it ?

example for my code in entity.designer.cs

public partial class entity: ObjectContext
   {
       public entity() : base(name=connetionstring, context)
       {
           this.ContextOptions.LazyLoadingEnabled = true;
           OnContextCreated();
       }

    }

i need to change the under line text in my run time

Posted 13-May-10 13:27pm

kimo code

Updated 6-Dec-11 17:34pm

Eduard Lu

v3

Add a Solution

Comments

Henry Minute 13-May-10 19:34pm

I added pre tags. changed nothing else.

[no name] 6-Dec-11 23:34pm

EDIT: added code blocks

Michel [mjbohn] 8-Dec-11 11:04am

That's quite an old post from 14.05.2010 :-)
How did it pop up again?

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Not Active · Answer 1 · 2010-05-13T14:55:00

There should be three constructors for the ObjectContext class

public Entities() : 
        base("name=Entities", "Entities")
{
    this.OnContextCreated();
}

public Entities(string connectionString) : 
        base(connectionString, "Entities")
{
    this.OnContextCreated();
}

public Entities(global::System.Data.EntityClient.EntityConnection connection) : 
        base(connection, "Entities")
{
    this.OnContextCreated();
}

Pass in the connection string or create an EntityConnection object

private static EntityConnection GetConnection()
{
    EntityConnectionStringBuilder entityBuilder = new EntityConnectionStringBuilder();
    entityBuilder.ProviderConnectionString = ConfigurationManager.ConnectionStrings["xxx"].ConnectionString;
    entityBuilder.Provider = "System.Data.SqlClient";
    entityBuilder.Metadata = @"res://*/xxx.csdl|res://*/xxx.ssdl|res://*/xxx.msl";

    return new EntityConnection(entityBuilder.ToString());
}

vinayakshenoy2000@gmail.com · Answer 2 · 2010-08-21T19:25:00

Hi,

You can get hold of the EntityConnection by ObjectContext instance.

ObjectContextInstance.Connection - and then type cast this to EntityConnection.

Then To this instance of EntityConnection, Get the storeConnection

EntityConnectionInstance.StoreConnection - this gives you the underlying connection string.

I hope this helps!.

Regards,
-Vinayak

Bahram Ettehadieh · Answer 3 · 2011-12-06T07:47:00

Solution 3

Set the connection string for Entity Framework at runtime[^]

Posted 6-Dec-11 7:47am

Bahram Ettehadieh

how to change the connection string in the EntityFramework ?

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0