Connect to D365 TDS (SQL) Endpoint from .Net Core 3.1

Recently i needed to implement a timer based Azure function to query and process data in D365 CE tables. Due to increasing volume of data i needed apply filters while reading data i.e, either Fetch / Query Expression / WebApi or somehow make it work with SQL. Here TDS (Table Data Stream Protocol: read?here) came in quite helpful as I could do much extended filtering in SQL than querying through Fetch or WebApi queries, saving all in-memory filtering complexity. So the next step was to connect to TDS endpoint for .Net Core 3.1 function code, as classic ADO.Net / SQL Linq DataExtensions is not supported.

Read the full article here