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
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?