web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Customer experience | Sales, Customer Insights,... / is it possible to run ...
Customer experience | Sales, Customer Insights,...
Unanswered

is it possible to run SQL queries from a plugin?

(0) ShareShare
ReportReport
Posted on by Jerome P1

Hi,

how can I run SQL queries from within a custom plugin (or maybe if there is a plugin available able to doing this) when using Dynamics CRM 365?

I really mean custom SQL queries.

I want to setup a risk management system on top of my data in Dynamics, each risk will be evaluated using an SQL query and I want to create a plugin to evaluate this query and store the result in an entity.

why SQL?

because my risks can be complicated and required to cross multiple entities.

I tried to create a plugin connected to the TDS access point, but its not working because the adsql.dll library is missing.

is there any option?

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at
    RE: is it possible to run SQL queries from a plugin?

    Hi,

    For your final request, you can provide your ideas in following forum:

    experience.dynamics.com/.../

    Regards,

    Leah Ju

  • Jerome P1 Profile Picture
    Jerome P1 on at
    RE: is it possible to run SQL queries from a plugin?

    thanks but my problem was how to access TDS from within a C# plugin.

    after a lot of research, I found that the problem is related to docker deployments, so the CRM appear to be in docker instances and not windows or linux ones.

    and the solution was to use the Microsoft.Data libraries and not the SqlServer librairies.

    but I hope microsoft will integrate a simple and direct access to the TDS end point.

  • Community Member Profile Picture
    Community Member on at
    RE: is it possible to run SQL queries from a plugin?

    Hi，

    Recently Microsoft has released new product feature where we can directly connect to SQL and write query into CSD Database. Currently this is in preview and not recommended for Product environment.

    You can refer following links for more details:

    Use SQL to query data (Microsoft Dataverse) - Power Apps | Microsoft Docs

    Use SQL to Query Data from CDS and Dynamics 365 CE (powerobjects.com)

    Setting up – Using SQL to query data in Dynamics 365 (Preview) – Nishant Rana's Weblog

    Regards,

    Leah Ju

    Please mark as verified if the answer is helpful. Welcome to join hot discussions in Dynamics 365 Forums.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Our Community Code of Conduct has been updated!

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Andrés Arias – Community Spotlight

We are honored to recognize Andrés Arias as our Community Spotlight honoree for…

Congratulations to the August Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1
Rishabh Kanaskar Profile Picture

Rishabh Kanaskar 258

#2
Daniyal Khaleel Profile Picture

Daniyal Khaleel 172

#3
Tom_Gioielli Profile Picture

Tom_Gioielli 75 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Hide selecting Contact for potential customer when creating quote

Product updates

Dynamics 365 release plans