• Create Data-Oriented Apps Faster

    DataConnectors provides fast and direct access to Dynamics 365 Sales services. It hides the complexity of connecting to Dynamics and offers a unified interface for performing common operations, such as queries and updates, against Dynamics and other 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, ultimately, 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.

ADO.NET, Entity Framework Core & LINQ Support

Connect to Dynamics 365 Sales data using standard ADO.NET objects and Entity Framework Core. The data connector uses ADO.NET objects like C1D365SConnection, C1D365SCommand, and C1D365SDataAdapter to make it easy to set up a connection. It also has in-built support for LINQ queries for native .NET data queries.

OpenAuth Authentication Support

The Dynamics365 data connector supports OpenAuth-based authentication to help you protect your data through a secure connection. OpenAuth provides an open-standard authorization protocol or framework that describes how unrelated servers and services can safely allow authenticated access to their assets without actually sharing the initial, related, single login credential.

SQL Query Support

Query against Dynamics 365 Sales data using standard SQL syntax. The data connectors support most SQL functionality including joins queries, functions, and summaries.

CRUD Operations

In addition to querying, the data connectors support other CRUD operations such as insertion, updating, and deleting data. The data connector supports these operations using Command and DataAdapter objects. Also, performance could be enhanced in these operations by using the Batch feature to submit changes in chunks over the network.

Fast Cache with Incremental Updates

The data connector has in-built caching in order to support local availability of data for faster performance on repeat operations. It also supports incremental updates so that only new or modified records get synced to the cache. This improves performance over time because your app does not need to perform a full refresh to update the cache. You can set the cache settings in connection object to configure cache database.

Scaffolding

Scaffolding is a reverse engineering technique that helps you quickly generate model classes based on the entities of your database. The data connector library has built-in support for the scaffolding technique similar to Entity Framework Core. When you run the scaffolding command in Visual Studio, the scaffold engine will generate model classes and a database context for EF Core.

More Data Integration Capabilities

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

  • Integrate OData with C1DataCollection to provide filtering, grouping, data virtualization to your data-aware controls.
  • Import data from OData to C1DataEngine 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 OData source.
  • Create business reports using FlexReport and OData for important business tasks.
  • Display data in a .NET FlexGrid control in desktop, web or mobile devices.