Windows Azure portal connection strings

Question

couple of questions regarding the connection strings section for websites in the windows azure portal:

do the settings in the portal take precedence over what's in web.config? If so, should I not include connection strings in the web.config file? Are the settings in the portal sometimes referred to as app.config?

can i set connection strings for ado.net entities in the windows azure portal? This does not seem to work for this specific type of connection string.

in the portal i included the following connection string and gave it the same name as what is in my web.config:

metadata=res:///Models.TABLENAME.csdl|res:///Models.TABLENAME.ssdl|res://*/Models.TABLENAME.msl;provider=System.Data.SqlClient;provider connection string="Server=tcp:SERVERNAME.database.windows.net;Database=DATABASENAME;User ID=USER;Password=PASSWORD;Trusted_Connection=False;Encrypt=True;

The connection string in my web.config file works in my dev environment, but i think i have something typed wrong on the azure portal.

is this for an Azure Website or WebRole?

viperguynaz
– viperguynaz

2013-01-03 03:19:54 +00:00
Commented Jan 3, 2013 at 3:19 — viperguynaz
– viperguynaz, Commented Jan 3, 2013 at 3:19
Related question: stackoverflow.com/questions/13782337/…

janv8000
– janv8000

2015-04-21 20:30:35 +00:00
Commented Apr 21, 2015 at 20:30 — janv8000
– janv8000, Commented Apr 21, 2015 at 20:30

Noctis · Accepted Answer · 2019-01-24 00:04:10Z

3

"do the settings in the portal take precedence over what's in web.config?" Yes.

"If so, should I not include connection strings in the web.config file? " Use the connectionstring found in Azure portal and insert it in your web.config. This, of course, does not apply to if you are using a local database. Then you should use the local connectionsstring.

"Are the settings in the portal sometimes referred to as app.config?" No. Not if you are stil on the subject of connectionstrings.

"can i set connection strings for ado.net entities in the windows azure portal? This does not seem to work for this specific type of connection string" Check my blog post on basic set up for this here under step 2(2. Now, go to the Management portal and Create a new db.) http://geekswithblogs.net/MagnusKarlsson/archive/2012/10/31/add-sql-azure-database-to-azure-web-role-and-persist.aspx

edited Jan 24, 2019 at 0:04

Noctis

11.8k3 gold badges46 silver badges86 bronze badges

answered Jan 3, 2013 at 10:06

Magnus Karlsson

3,5543 gold badges33 silver badges58 bronze badges

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

1 Comment

robocopgodzilla Over a year ago

thanks mate. very helpful information. i'm new to mvc and most of its parts.

Collectives™ on Stack Overflow

Windows Azure portal connection strings

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related