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.
SQL 4 CDS 5.3 Released
I asked a little while ago what new features you’d most like, so here’s the first of them: cross-instance queries!
Connecting to on-prem Dynamics from .NET Core without OAuth
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
Merge Permissions Tool
One of my most popular blog posts, and one I keep finding myself referring back to, is on the D365 merging process. It’s often difficult to get security roles just right so they allow merging records without giving way too many permissions. Finally, I’ve finished a tool I’ve wanted for Continue Reading