Intellipaat Back

Explore Courses Blog Tutorials Interview Questions
0 votes
2 views
in Azure by (13.1k points)
Is there any possibility to connect directly to Azure SQL using my Visual Studio?

1 Answer

0 votes
by (26.7k points)

Try the following steps to connect to Azure SQL using Visual Studio

1. Open your project file in Visual Studio.

2. In the Solution Explorer, right-click on Connected Services node, and, from the menu, select Add Connected Service.

3. In the Connected Services tab, select the + add icon for Service Dependencies.

4. In the Add Dependency page, select Azure SQL Database.

5. In the Configure Azure SQL Database screen, select an existing Azure SQL Database, and select Next.

6. Enter a connection string name, or choose the default, and choose whether you want the connection string stored in a local secrets file, or in Azure Key Vault.

7. The connection appears under the Service Dependencies section of the Connected Services tab.

I hope this will work.

Want to become an Azure Expert? join azure certification now!!

31k questions

32.8k answers

501 comments

693 users

Browse Categories

...