CODEWITHSUNDEEP
c#databaseazureazure-web-app-service
Valentin Kohler
Valentin Kohler

Reputation: 11

How to change connexion string in a deployed Azure App

I have developed a website application under visual studio using the MVC Pattern and Entity Framework 6. This web app was linked to a local database.

I've published the application on my azure acc. I also exported the database on Azure following this tutorial. However, I can't find a way to link the online app to the migrated database.

No data is displayed on the app and when I try to check for the connexion string I get an error , the connexion string hasn't been updated and therefore the app is still trying to target my local database.

I would like to know if anyone might know how to solve this.

EDIT : The problem may be somewhere else, I apparently have two connexions , one for my migrated DB and one for my local db. Perhaps I need to remove the connexion string targetting my local DB but I don't know how to do that Also, since the Migrated database is a copy from the local one I was using before, do I need to change anything in my Model,views or controller ?

EDIT2 : Thanks to the comment below I was able to override the false Connexion String. However my datas are still not displayed on my application and I haven't found yet what could have happend. I suspect that my model is still the same model as the one used by the local database as it has the same name. Does anybody know how to change the model to the current model of the online database ?

Thanks.

Upvotes: 1

Views: 52

Answers (1)

Christoph Hauer
Christoph Hauer

Reputation: 71

Because you created your app with entity framework there should be a connection string defined in the web.config file pointing to the local database.

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

If you have published your Website as WebApp (App Service) then you can change the connection string for the database under the Application Settings pane on the WebApp Page. You can override your connection string by creating a connection string settings entry with the name of the connection string in the web.config file. (For the snippet above - MyContext)

Upvotes: 2

Related Questions