.NET Connector for Dynamics 365 with ORM Support

dotConnect for Dynamics 365 (formerly Dynamics CRM) is a high-end ADO.NET data provider for accessing and managing Dynamics 365 data through the standard ADO.NET or Entity Framework interfaces. It helps you easily integrate Dynamics 365 data into .NET applications.

Our data provider has the same standard ADO.NET classes as other providers. This helps you get started quickly and eliminates the need to study any specifics of Dynamics 365.

Broad compatibility with .NET platforms, including WPF, Blazor, MAUI, Windows Forms, etc.
ORM support: EF Core, Dapper, NHibernate, etc.
Full compliance with ADO.NET
Integration with Visual Studio and design-time support
Regular updates and detailed documentation

Easy Integration With Dynamics 365

Integrate Dynamics 365 into your .NET applications through the standard ADO.NET interface.

No need to use an overcomplicated API

You don't have to study and use the Dynamics 365 API. SQL queries will make data retrieval much easier.

User-friendly ADO.NET classes

Get started quickly with the familiar ADO.NET classes used by dotConnect for Dynamics 365.

Worry-Free Connection to Dynamics 365

dotConnect for Dynamics 365, first and foremost, provides quick and easy connection to Dynamics 365 and access to its data, required for integration with your applications.

Easy connection without any client libraries
Full support for SQL queries and API calls
Robust security features with advanced encryption and authentication
Flexible connectivity options for diverse operational environments
Cost-effective deployment

Advanced ORM Support

dotConnect for Dynamics 365 offers enhanced ORM support with a bundled Entity Developer — visual designer for ORM models:

Entity Framework Core

1.x, 2.x, 3.x, 5.0, 6.0, 7.0, 8.0, and 9.0

NHibernate

1.x-5.x

Entity Framework

V1-V6

Dapper

1.x, 2.x

Learn more

Single Connector for Any SQL Queries

dotConnect for Dynamics 365 simplifies your data management by allowing you to write and execute SQL queries directly against Dynamics 365. With its help, you can handle all kinds of information with ease - give it a try and see for yourself.

Data Management Via SQL Queries: SQL is the ultimate language for work with data. No wonder it's the cornerstone of the most popular database systems. And now you can use it to interact with data from Dynamics 365.
Full CRUD Support: Perform CREATE, READ, UPDATE, and DELETE operations using standard SQL statements.
Advanced SQL Capabilities: Apply complex JOINs, WHERE conditions, and other features of SQL to make operations with data most precise and flexible.
Broad Object Access: Use SQL to work with Dynamics 365 accounts, contacts, leads, contracts, products, campaigns, opportunities, and other objects.

How SQL Connector for Dynamics 365 Works

Our Dynamics 365 Data Flow Components handles queries by splitting complex ones into parts for execution on Dynamics 365, with advanced processing by a local SQL engine, while simple queries are directly compiled into Dynamics 365 API calls for optimal performance.