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
Identifying merged records
You can use duplicate detection rules to find duplicate records in Dynamics 365 (or do it even better with Data8 Duplicare!), but how do you go back and find what records have been merged, or by whom?
Integrating SQL 4 CDS with your own XrmToolBox tool
One for the XrmToolBox developers: if you want to make use of the power of SQL 4 CDS from your own tool, how can you do it?
SQL 4 CDS 5.2.2 Released
I’ve just released SQL 4 CDS 5.2.2! Upgrade today for a bunch of useful updates, fixes and improvements.
Faster Web API Metadata Access
I was recently updating a Javascript web resource that needs to use the Dataverse Web API to get some table metadata. This was taking around 5 seconds to get all the information it needed, but with a few changes I got that down to about 0.2 seconds.