SQL 4 CDS allows you to use standard SQL syntax to query and manipulate your data and metadata in CDS / D365.
Supports - SELECT - INSERT - UPDATE - DELETE
Where possible the queries are converted to FetchXML, allowing you to generate FetchXML queries for plugins or integrations by writing familiar SQL and converting it.
Using the preview T-SQL endpoint, SELECT queries can also be run that aren't convertible to FetchXML.
Latest version release notes
Extended TDS endpoint supoprt Fixed inserts into multi-select picklist attributes
Absolutely fantastic plugin for anyone who's at home in SQL, and misses the power and flexibility of SQL when working with Dynamics365 - wonderful job, Mark! Couldn't do my work without your plugin!
(Durgaprasad Katari, )
Great tool, can enable TDS endpoint easily without running the orgDBsettings exe.
(Nishant Rana, )
Awesome tool. Thanks !
(Patrick Lauziere, )
Great tool to extract data in fields order you want.
(Nicola Micheletto, )
(CRM Admin, )
(Rich Waring, )
Great to have a way to effectively run sql queries against the D365 back end - saved me a lot of time today.
Related information
Author: Mark CarringtonLatest version: 4.0.0Released on: 01/13/2021Nuget package Id: MarkMpn.SQL4CDSOpen Source: trueGo to project web site Ratings (all versions)5Average rating9Number of ratings Downloads1418Latest version32345All versions1617.25Average per version