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.
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.
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
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 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
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
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
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.
I asked a little while ago what new features you’d most like, so here’s the first of them: cross-instance queries!
If you’re like me you’ll have been excited recently with all the improvements coming in .NET, first with .NET Core and now with .NET 5 and 6. But as Dynamics developers we’ve been locked into using .NET Framework by the Dynamics SDK. Thankfully that’s changing with the preview Dataverse ServiceClient, Continue Reading