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.

The project is configured with a SQL Server connection and TypeORM by default. However it is easly to change it's database connection thanks to its great ecosystem of connectors.