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.

Microsoft has open sourced a .NET 5 C# Language Extension for SQL Server, allowing developers to work with relational data in the company's flagship programming language.