Create an ASP.NET MVC app with auth and SQL DB and deploy to Azure App Service
above is a link to a tutorial that I followed to create a database and manipulate seeded data with a MVC app.
I am currently learning about ASP.NET & Azure in my internship. How would I go about connecting to an existing database to run CRUD operations on a table that already has data in it? How would the data already in the table show up on the page?
Take a look at your web.config file. You'll find a section:
<connectionString>
<add key="DefaultDB" value="....."/>
</connectionString>
Just change it to your existing database. Another option, you can change the connection string when you'll publish the application:
If you followed the steps on the previous link you've post, just skip the step:
Since you'll already have a database server, you won't need to create a new one.
If you are trying to use an existing DB when publishing then you can Right Click the web project in the solution explorer node and select Publish. Then you can create a publish profile to your remote site. On the settings tab you should see an entry for the connection string. In that dialog you can place a new connection string that should be used when you publish your application.
