MSSQL: Edit DB in VS2019

Editing For MSSQL: To connect to the database live, and edit it

1. Go to View => Server Explore
   

2. Right-click "Data Connections"

3. Click "Add Connection"
   Step 2+3

4. Use the same credentials as in For MSSQL: To update the database project (only do this if database is complete) (step 3 to 6)

5. You should now be connected to the DB

6. To edit tables:

   1. Right-click a table
   2. Click "Design"
      Step 6.ii
   3. Edit what you want
   4. Click the update button in the top left corner

7. To edit table data:

   1. Right-click a table
   2. Click "Retrieve data"
      Step 7.ii
   3. Edit what data you want, every time you go to a new row, it automatically updates the database