[WebToolsE2E][Multiple docs] Some instructions need to be updated in "Tutorial: Deploy a .NET Aspire project with a SQL Server Database to Azure"

[v-reinawang]

Describe the issue or suggestion

Issue description:
In "Tutorial: Deploy a .NET Aspire project with a SQL Server Database to Azure" doc, we need to make some updates to the instructions.

Issue1: [This problem exists in multiple documents]
The code in the document does not contain "WaitFor()".

Expected:
The created Aspire Starter project contains the code "WaitFor()" by default.

Issue2:
The code provided by the document[Configure the AppHost project] is obsolete.

Expected: We can use AddAzureSqlServer instead of PublishAsAzureSqlDatabase

Issue3: [This problem exists in multiple documents]
The azd up part of the documentation needs to be updated.

Expected:
There is no SUCCESS information, and the Aspire Dashboard link is added.

---

Associated WorkItem - 341259