This blogpost explains how to connect .NET Core Console application to SQL server database and read table data. You will not be using the Entity framework for this.

That will connect to Azure SQL and deploy the needed database objects and some sample data.