Skip to content
Primary Menu
  • Home
  • About
  • Blog
  • SQL 4 CDS
  • Twitter
  • LinkedIn
  • GitHub
Mark Carrington

Data, D365, Diabetes, Lego, …

T-SQL

Covering the T-SQL endpoint for CDS that was announced at MBAS 2020 and is currently in public preview.

  • Home
  • MSDyn365
  • T-SQL
  • Page 2
Category: MSDyn365/T-SQL

CDS T-SQL endpoint pt 5 – EntityFramework / ORM

Posted On 16th May 202028th September 2020 By Mark Carringtoncomment

Now I can reliably connect to the CDS T-SQL endpoint and execute queries against it, I want to get the data into some objects for me to use. I currently use EntityFramework and Dapper for this in other projects, so I’ll take a look at those two.

Category: MSDyn365/T-SQL

CDS T-SQL endpoint pt 4 – Performance

Posted On 15th May 202028th September 2020 By Mark Carringtoncomment

A common question I’ve seen so far about the new CDS T-SQL endpoint is how it compares performance-wise to using FetchXML. After all, FetchXML is “native” to CDS while T-SQL might be viewed as the johnny-come-lately compatibility layer, so it’s going to be slower, right?

Category: MSDyn365/T-SQL

CDS T-SQL endpoint pt 3 – SqlClient

Posted On 14th May 202028th September 2020 By Mark Carrington14 Comments

As a developer, the first thing I want to do with any new tool is try and integrate or extend it with my own code. This is always one of the real benefits of CDS and the Power Platform for me, as it’s so much more open to extensibility than Continue Reading

Category: MSDyn365/T-SQL

CDS T-SQL endpoint pt 2 – First Thoughts

Posted On 13th May 202028th September 2020 By Mark Carrington2 Comments

Let me just say, this thing is going to be great. It’s the biggest advancement in the platform for some years, and I don’t think any competitor will come close. However, it is a preview feature, and it does have some issues. Hopefully some of these at least will get Continue Reading

Category: MSDyn365/T-SQL

CDS T-SQL Endpoint pt 1 – Connecting

Posted On 13th May 202022nd October 2020 By Mark Carrington12 Comments

The biggest announcement of MBAS for me by a long way was the new T-SQL endpoint. For those who missed it, go and check out the recordings.

Posts navigation

Previous 1 2

Copyright © All rights reserved Theme: Infinity Blog by Themeinwp