Entity Framework set connection string at runtime

Question

I have been trying to get this work for last couple of days with no success.

This is what I have done so far.

string providerName = "System.Data.SqlClient";
string serverName = serverIPAddress;
string databaseName = myDBName;

SqlConnectionStringBuilder sqlBuilder = new SqlConnectionStringBuilder();

sqlBuilder.DataSource = serverName;
sqlBuilder.InitialCatalog = databaseName;
sqlBuilder.PersistSecurityInfo = true;
sqlBuilder.MultipleActiveResultSets = true;
sqlBuilder.UserID = "sa";
sqlBuilder.Password = saPassword;

string providerString = sqlBuilder.ToString();

EntityConnectionStringBuilder entityBuilder = new EntityConnectionStringBuilder();

entityBuilder.Provider = providerName;

entityBuilder.ProviderConnectionString = providerString;

entityBuilder.Metadata = "res://*/TUModel.myModel.csdl|res://*/TUModel.myModel.ssdl|res://*/TUModel.myModel.msl";            
myEntities ctx = new myEntities(entityBuilder.ConnectionString);

The constructor in entity class look like

public myEntities(string connectionString) : base("name=myEntities")
{
}

When I run there is no error. However if I delete 'myEntities' connection string from app.config, then it throws exception. If I leave it as it is then it ignores the connection string in the code and use the one in app.config.

Any help would be greatly appreciated.

DavidG · Accepted Answer · 2015-08-13 13:49:22Z

2

Your context constructor isn't passing your connection string in, instead it is passing through a fixed value of name=myEntities. Change it to this:

public myEntities(string connectionString) : base(connectionString)
{
}

answered Aug 13, 2015 at 13:49

DavidG

120k13 gold badges232 silver badges239 bronze badges

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

Collectives™ on Stack Overflow

Entity Framework set connection string at runtime

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related