Customize DbContext using connection string from ServiceConfiguration (Azure)

Question

I am using the entity-framework with Code First approach and I have a custom DbContext. My connectionstring is defined in the ServiceConfiguration.Cloud.cscfg and ServiceConfiguration.Local.cscfg files.

 public CustomContext()
                : base("dbActivity")
 {
    ...

When the above code executes, it tries to check my web.config and not the ServiceConfiguration file from an azure solution.

UPDATE: Here is my connectionString in the ServiceConfiguration file:

<ConfigurationSettings>
  <Setting name="Microsoft.WindowsAzure.Plugins.Diagnostics.ConnectionString" value="UseDevelopmentStorage=true" />
  <Setting name="dbActivity" value="Server=tcp:xxx.database.windows.net,1433;Database=ra;User ID=user;Password=password;Trusted_Connection=False;Encrypt=True;Connection Timeout=30;" />
</ConfigurationSettings>

Exception:

No connection string named 'Server=tcp:xxx.database.windows.net,1433;Database=ra;User ID=user;Password=password;Trusted_Connection=False;Encrypt=True;Connection Timeout=30;' could be found in the application config file."

Is it possible to make it check the ServiceConfiguration.Local.cscfg instead?

possible duplicate of Configure Entity Framework to pick connection strings from Azure CloudConfiguration File? — Abhijeet
– Abhijeet, Commented Oct 10, 2014 at 12:52

Bonomi · Accepted Answer · 2014-11-03 10:47:12Z

2

Finally I found the solution. It's necessary to use the SqlConnectionStringBuilder class.

public RAActivityContext()
    : base((new SqlConnectionStringBuilder(
            CloudConfigurationManager.GetSetting("dbRAActivity")).ToString()))
{            

}

answered Nov 3, 2014 at 10:47

Bonomi

2,7637 gold badges40 silver badges55 bronze badges

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

Comments

Brendan Green · Accepted Answer · 2014-10-10 12:01:46Z

0

There is an overloaded constructor that takes an actual connection string.

This should do the trick:

public CustomContext()
                : base(CloudConfigurationManager.GetSetting("dbActivity"))
{
    // stuff here
}

Of course, the setting contains the (full) connection string.

answered Oct 10, 2014 at 12:01

Brendan Green

11.9k5 gold badges47 silver badges82 bronze badges

4 Comments

Bonomi Over a year ago

I tried this solution before, but I still get the same exception. It looks like it is only accepting the connection string name, not the connection string itself

Brendan Green Over a year ago

What is the exception that is thrown? What version of EF are you using? What does the configuration in your ServiceConfiguration.Local.cscfg look like? I am doing the above and it is working fine with EF 6.

Brendan Green Over a year ago

WebRole or WorkerRole? Version of EF?

Bonomi Over a year ago

I am using EF6 and WorkerRole

David Turvey · Accepted Answer · 2014-10-10 12:01:58Z

0

I don't know it you can directly load it from a different config but there is a constructor for dbcontext that takes a connection string as input.

string connectionString = LoadFromConfig();
var context = new CustomContext(connectionString );

answered Oct 10, 2014 at 12:01

David Turvey

2,9716 gold badges27 silver badges29 bronze badges

Comments

Community · Accepted Answer · 2017-05-23 12:08:38Z

I needed to do this, but wasn't able to change the actual DbContext constructor as it was in a shared library that was also used by projects that used an app.config. I ended out coming up with an alternative solution which was to programatically modify the app.config connection string inside the worker role itself.

See this for a way to do that: Change connection string & reload app.config at run time

The code I used was

string databaseConnectionString = CloudConfigurationManager.GetSetting("dbActivity");
Configuration config = ConfigurationManager.OpenExeConfiguration(ConfigurationUserLevel.None);
ConnectionStringsSection connectionStringsSection = (ConnectionStringsSection) config.GetSection("connectionStrings");
connectionStringsSection.ConnectionStrings["dbActivity"].ConnectionString = databaseConnectionString;
config.Save();
ConfigurationManager.RefreshSection("connectionStrings");

For this to work you need to have an empty connection string inside the app.config for which it will overwrite

<connectionStrings>
    <add name="dbActivity" connectionString="" providerName="System.Data.SqlClient" />
</connectionStrings>

Collectives™ on Stack Overflow

Customize DbContext using connection string from ServiceConfiguration (Azure)

4 Answers 4

Comments

4 Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

4 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related