A cross-platform, data connectivity library for connecting to any OData data source.
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.
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.
The DataConnectors library is built against .NET Standard from the ground up so it's supported across Windows, Mac, Linux and mobile device platforms.
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.
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.
Query against OData services using standard SQL syntax. The data connectors support most SQL functionality including joins queries, functions, and summaries.
In addition to querying, the OData connector supports other CRUD operations such as insertion, updating and deleting data.
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 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.
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.
Ken Spenser, Microsoft Regional Director - Framework Masters
Silv Sordello, Software Developer
Dennis Wallentin, Microsoft MVP (Excel)
Michelle Gibson, Software Engineer