changing database in entity framework c#.net

Question

Let us consider the entity class listed as

public NerdDinnerEntities() : base("name=NerdDinnerEntities", "NerdDinnerEntities")
        {

            this.ContextOptions.LazyLoadingEnabled = true;

            OnContextCreated();
        }

        /// <summary>
        /// Initialize a new NerdDinnerEntities object.
        /// </summary>
        public NerdDinnerEntities(string connectionString) : base(connectionString, "NerdDinnerEntities")
        {
            this.ContextOptions.LazyLoadingEnabled = true;

            OnContextCreated();
        }



        /// <summary>
        /// Initialize a new NerdDinnerEntities object.
        /// </summary>
        public NerdDinnerEntities(EntityConnection connection) : base(connection, "NerdDinnerEntities")
        {
            this.ContextOptions.LazyLoadingEnabled = true;
            OnContextCreated();
        }

and these being read as in web config file as

<add name="NerdDinnerEntities" 
    connectionString="metadata=res://*/Models.NerdDinner.csdl|res://*/Models.NerdDinner.ssdl|res://*/Models.NerdDinner.msl;provider=System.Data.SqlClient;provider connection string=&quot;Data Source=*;
    Initial Catalog=db;User ID=*;Password=****;
    MultipleActiveResultSets=True&quot;" providerName="System.Data.EntityClient" />

and my problem is i need to change the database name from db to db1 through code with out change in web config file..

as enitity as a class name called changedatabase() .. but i do not know how to use it...

and my another question is it possible to add a new dll in to this project and change the connectionstring meta data there by when ever the connection is opened there by it will come to that dll and change the database name only and return with that database...

Waiting for your valuable commands and sugessions

Amiram Korach · Accepted Answer · 2012-07-30 09:13:37Z

1

public class MyEntities : NerdDinnerEntities
{
  public MyEntities() : base(GetConnectionString())
  {
  }

  private string GetConnectionString()
  {
    var connectionString = System.Configuration.ConfigurationManager.
        ConnectionStrings["connectionStringName"].ConnectionString;
    var builder = new System.Data.Common.DbConnectionStringBuilder();
    builder.ConnectionString = connectionString;
    var internalConnectionString = builder["provider connection string"].ToString();
    var newConnectionString = internalConnectionString.Replace("oldDBName", "newDBName");
    builder["provider connection string"] = newConnectionString;
    return builder.ConnectionString;
  }
}

edited Jul 30, 2012 at 9:13

answered Jul 30, 2012 at 7:35

Amiram Korach

13.3k3 gold badges32 silver badges32 bronze badges

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

10 Comments

GowthamanSS Over a year ago

thanks for posting ! i do not know where to use this code! can u say me!

Amiram Korach Over a year ago

If you want this change to be permanent then you can replace the connection string in the web.config file, and yes, you can do it from a dll.

GowthamanSS Over a year ago

ya i want it through dll... i need to create a library file in which inherits dbcontext and place this coding in it ... has i want to change anything in web.config file... give me some tips reg it

GowthamanSS Over a year ago

the above is my entity class since this concept is new to me i do not know how to proceed with dll ? need ur guidelines /......

Amiram Korach Over a year ago

In your inherited class (from NerdDinnerEntities), add this code in the parameterless constructor and call your base class constructor that gets a connection string as a paremeter

|

Collectives™ on Stack Overflow

changing database in entity framework c#.net

1 Answer 1

10 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

10 Comments

Your Answer

Sign up or log in

Post as a guest

Related