.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, LinqConnect, etc.
  • Full compliance with ADO.NET
  • SSL, SSH, proxy servers, and HTTP tunnels support
  • Integration with Visual Studio and design-time support
  • Regular updates and detailed documentation
Easy Integration With Dynamics 365

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

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

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, and 8.0

NHibernate

1.x-5.x

Entity Framework

V1-v6

Dapper

1.x, 2.x

Broad Compatibility

dotConnect for Dynamics 365 is the only data provider of its kind that supports both modern platforms and technologies as well as deprecated technologies, which is an excellent way to reduce integration costs for existing applications.

Platforms
  • .NET 5, 6, 7, 8
  • .NET Framework 2.0-4.8
  • .NET Core 1.x, 2.x, and 3.0
  • ASP.NET Core Blazor
  • .NET MAUI
Dynamics 365 WEB API

All versions

Microsoft Visual Studio

Visual Studio 2008-2022

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.

More articles