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.

Remote MCP Database Server A production-ready Model Context Protocol (MCP) server that provides AI applications with secure access to a PostgreSQL database over HTTP. This server demonstrates how to ...