I’ve just published SQL 4 CDS 6.4 with support for earlier versions of CRM and more complex queries. I’ve also been setting up a wiki with more detailed information.
SQL 4 CDS 6.3 Released
I’ve just released SQL 4 CDS v6.3 with a number of useful improvements and fixes.
SQL 4 CDS 6.2 Released
This is mostly a bug fix release, but with one new SQL feature implemented which could be very useful for testing and ALM usage scenarios.
SQL 4 CDS 6.1 Released
It’s only been a month since I released v6, but I’ve just published v6.1 with some useful new updates. You’ll need to make sure you’re running the latest version of XrmToolBox (1.2022.4.55) to run this new version.
SQL 4 CDS v6 Released
It’s time for another big update to SQL 4 CDS – this one’s been in the works for 3 months and has got some great improvements to its level of SQL support, performance, integration with SSMS and reusability in custom apps. New SQL support: Variables You can now declare and Continue Reading
SQL 4 CDS ADO.NET Provider
As well as lots of new SQL language support in SQL 4 CDS v6, I also tried to make it much easier to reuse the SQL 4 CDS engine in your own applications. The latest version of the NuGet package now includes an ADO.NET provider you can use in exactly Continue Reading
Relationship Mappings: String Length Too Long
Relationship mappings are a great feature in Dataverse. If you haven’t seen them before you’re probably not alone – the interface to edit them is pretty well hidden away in the classic UI. These mappings let you create related records with fields already filled out based on the parent record. Continue Reading
On-Prem Dynamics CRM/365: AD authentication from .NET Core
Back in November I released the first version of the Data8.PowerPlatform.Dataverse.Client NuGet package to let developers connect to on-prem Dynamics CRM/365 instances using claims-based or IFD authentication without having to configure OAuth. I’ve now released an update to this package – version 2.0.0 also includes support for Active Directory (AD) Continue Reading
FetchXML Aggregate Queries, Lookup Fields and Paging
David Fraticelli raised an interesting bug that became apparent in SQL 4 CDS. Many thanks to David for all his help in tracking down what was happening. I’ve mentioned before the many ways that paging in FetchXML can give rise to unexpected results. One key thing to ensure you get Continue Reading
SQL 4 CDS 5.4 Released
This update focuses mainly on aggregate query performance and introduces .NET Core compatibility for developers wanting to integrate SQL 4 CDS with their own applications.