How to connect to azure SQL server using visual studio

Question

Is there any possibility to connect directly to Azure SQL using my Visual Studio?

Answer 1

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!!