• Create Data-Oriented Apps Faster

    DataConnectors provides fast and direct access to online OData sources. It offers a unified interface for performing common operations, such as queries and updates, against OData and other sources.

  • Manage Data More Efficiently

    Integrate data from OData services 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 OData 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 online data sources using standard ADO.NET objects and Entity Framework Core. The data connector uses ADO.NET objects like C1ODataConnection, C1ODataCommand, and C1ODataDataAdapter 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 OData data connector supports OpenAuth-based authentication to help you protect your data through a secure connection. Safely allow authenticated access to their assets without actually sharing the initial, related, single login credential.

SQL Query Support

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

CRUD Operations

In addition to querying, the OData connector supports other CRUD operations such as insertion, updating and deleting data.

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.