• Create Data Oriented Apps Faster

    DataConnectors provides fast and direct access to a variety of data sources. It hides the complexity and offers a unified interface for performing common operations, such as queries and updates, against multiple data sources.

  • Manage Data More Efficiently

    Integrate data from various sources 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 Data 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.

Supported Data Sources

Dynamics 365

A cross-platform, data connectivity library for connecting to Microsoft Dynamics 365 Cloud-based CRM.

Learn More

Salesforce

A Salesforce .NET data connector for cross-platform data integration and management.

Learn More

OData

A cross-platform, data connectivity library for connecting to any OData data source.

Learn More

Kintone

Connect to Kintone and integrate with your .NET apps..

Learn More

ADO.NET, Entity Framework Core & LINQ Support

Connect to online data sources using standard ADO.NET objects and Entity Framework Core. The data connector uses simple ADO.NET objects to make it quick and easy to set up a connection. It also has in-built support for LINQ queries for native .NET data queries.

OpenAuth Authentication Support

The data connectors support OpenAuth-based authentication to help you protect your data through a secure connection. OpenAuth is 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 the data source 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.