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.

A Visual Studio Code extension which extends the SQLTools extension, with a driver to work with the SAP HANA Database. It supports tables and views, as well as running queries on an SAP HANA Database.