Add Dynamics Data to .NET

A cross-platform, data connectivity library for connecting to Microsoft Dynamics 365 Sales CRM in your .NET applications.

  • Import data from Dynamics 365 to analyze against data from other locations
  • Perform any data operation, such as queries and updates
  • Quickly and easily display data or generate reports
  • Cross-platform .NET Standard support

The Dynamics 365 data connector is part of ComponentOne Data Services.

Download Free Trial (2022v3)

Why Choose ComponentOne DataConnectors?

Create Data-Oriented Apps Faster

Get fast and direct access to Dynamics 365 Sales services with less of the complexity through a unified interface for querying against all supported data sources.

Manage Data More Efficiently

Integrate data from Dynamics 365 into your custom applications without relying on additional software. This empowers end-users to manage data more efficiently and gain better insights.

Connect to Dynamics 365 from Any Platform

The DataConnectors library is built against .NET Standard from the ground up so it's supported across Windows, Mac, Linux, and mobile device platforms.

Visual Studio Integration

With full Visual Studio 2019 and Visual Studio 2022 integration, you can quickly and easily connect to your Dynamics 365 data sources. Connect to Dynamics through the Server Explorer, without writing a single line of C# code, and then drag tables on the dataset designer, and connect data-aware controls like grids, charts and report designers.

Data Features

ADO.NET and Entity Framework Core Support

Connect to Dynamics 365 Sales data using standard ADO.NET objects and Entity Framework Core. The data connector uses ADO.NET objects to make it easy to set up a connection. 

OAuth Authentication Support

The Dynamics 365 data connector library supports the industry standard authentication protocol, OAuth 2.0, to help you protect your data through a secure connection.

SQL and LINQ Query Support

Query against Dynamics 365 Sales data using most standard SQL syntax including joins queries, functions, and summaries. It also has in-built support for LINQ queries for native .NET data queries.

Batch CRUD Operations

The data connectors support CRUD operations such as inserting, updating and deleting data through Command and DataAdapter objects. You can further optimize network performance by performing batch updates.

Fast Cache with Incremental Updates

With built-in caching you can improve performance by using a local cache database for repeat operations. It also supports incremental updates so that only new or modified records get synced to the cache.

Scaffolding

With scaffolding support, the Dynamics 365 data connector library can generate model classes and a database context for Entity Framework Core. The scaffolding command can be run from Visual Studio.

Integrate Dynamics Data to .NET

While the Dynamics 365 connector focuses primarily on the connecting and querying, you can use it with other powerful .NET components to do a lot more.

  • Integrate Dynamics with DataCollection to provide filtering, grouping, data virtualization to your data-aware controls.
  • Import data from Dynamics to DataEngine to analyze massive amounts of data in fractions of a second.
  • Connect to pivot grids & charts, such as FlexPivot, to visually analyze data from the CRM.
  • Create business reports using FlexReport and your CRM for important business tasks.
  • Display data in a .NET datagrid using the FlexGrid control for desktop, web, or mobile devices.

Dynamics .NET Demos

Desktop DataConnectors Explorer

If you have a Dynamics 365 Sales account you can explore it through our DataConnectors Explorer on Windows by downloading the desktop Demo Explorer.

OLAP Invoice Report

See how to connect to various data sources, including Dynamics 365, in this web demo for our cross-platform data connectivity library.

ComponentOne Customer Feedback and Awards

"Prompt responses, quality feedback, and help with code examples. Fantastic service!"

RICHARD HERBERT

"Excellent product with good support"

MIKE WEBSTER

"I am very appreciative of the effort your entire team gave to make this transaction happen. Thank you for your efforts!"

SAM COLE

ComponentSource #2 Publisher 2022 Award ComponentSource #3 Product 2022 Award

"I love to use C1 components! I can be confident that if I need to do a particular task, ComponentOne will have the control to do the job."

SILV SORDELLO, SOFTWARE DEVELOPER

"As an ISV, I need tools that allow me to be competitive. Therefore, it's a must to use reliable and stable tools for customized solutions...ComponentOne provides all that to me and even more!"

DENNIS WALLENTIN, MICROSOFT MVP (EXCEL)

"Easier to use right off the bat. I liked using the Scheduler for drag-and-drop capability."

MICHELLE GIBSON, SOFTWARE ENGINEER