Skip to content
SQL 4 CDS core engine and XrmToolbox tool
C#
Branch: master
Clone or download
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Type Name Latest commit message Commit time
Failed to load latest commit information.
MarkMpn.Sql4Cds.Engine.Tests
MarkMpn.Sql4Cds.Engine Sort the items within <entity> and <link-entity> elements Jan 31, 2020
MarkMpn.Sql4Cds Updated packages to fix error with latest XrmToolBox update Feb 3, 2020
.gitattributes Add .gitignore and .gitattributes. Oct 29, 2019
.gitignore Exclude nuspec Jan 31, 2020
MarkMpn.Sql4Cds.sln Sort the items within <entity> and <link-entity> elements Jan 31, 2020
README.md Added README Jan 31, 2020

README.md

SQL 4 CDS

By Mark Carrington, supported by Data8

SQL 4 CDS provides an engine and XrmToolBox tool for using standard SQL syntax to query data stored in CDS / Microsoft Dynamics 365.

It converts the provided SQL query into the corresponding FetchXML syntax and allows the associated query to be executed, including the following types of query:

  • SELECT
  • INSERT
  • UPDATE
  • DELETE

The engine converts all the SQL syntax that has a direct equivalent in FetchXML. It will also use some other options to improve the execution of specific queries, including:

  • Faster SELECT count(*) FROM entity query execution using RetrieveTotalRecordCountRequest
  • Work around AggregateQueryRecordLimit errors by retrieving all the individual records and applying the aggregation in-memory.
You can’t perform that action at this time.