Would you rather maintain this: <condition attribute="createdon" operator="last-x-days" value="30"/> or this: .Where(l => l.CreatedOn.LastXDays(30)) Same FetchXml. One of them is typed and…

Aggregate Dataverse in LINQ: await service.Queryable<Opportunity>() .GroupBy(o => o.ActualCloseOn.Value.Year) .Select(g => new { g.Key, Total = g.Sum(o => o.ActualValue) }) .ToListAsync(); Group by…

Cross-apply, in LINQ: from a in service.Queryable<Account>() join c in service.Queryable<Contact>().WithFirstRow() on a.AccountId equals select new { c.FullName } One row per parent — the SDK…

I bet you didn't know you can see the FetchXml your LINQ will run. var fetch = service.Queryable<Account>() .Where(a => .ToFetchXml(); The SDK provider can't. Only PowerPortalsPro.Dataverse.Linq.…

Did you know you can stream Dataverse results page-by-page with LINQ? await service.Queryable<Contact>() .WithPageSize(500) .ForEachPageAsync(async page => await ProcessAsync(page)); No paging…

The Dataverse SDK already has a LINQ provider. It stops where queries get interesting: no async, no GroupBy, no server-side aggregates, no Any/All subqueries, no way to see the FetchXml.…