Author : HASSAN MD TAREQ

Prepare Database

See: setup database

Connect Database to SQL Server Object Explorer

SQL Server Developer Edition

Azure SQL

If private endpoint is created for Azure sql server i.e. 10.22.333.55 foo-test.database.windows.net

# Copyright (c) 1993-2009 Microsoft Corp.
#
# This is a sample HOSTS file used by Microsoft TCP/IP for Windows.
#


# localhost name resolution is handled within DNS itself.
#	127.0.0.1       localhost
#	::1             localhost
10.22.333.55 foo-test.database.windows.net

Now get the Azure SQL connection string and:

SQL Server Object Explorer - connecting to Azure SQL

Ensure EF Core Power Tools

Step-1

Installing Entity Framework Core Power Tools Step 1

Step-2

Installing Entity Framework Core Power Tools Step 2

Step-3

Installing Entity Framework Core Power Tools Step 3