Create Faster Data-Oriented Apps
Instantly connect your .NET app to any JSON data source. The data connector hides the complexity of connecting to JSON and offers a unified interface for performing common operations, such as select queries and authentication against multiple sources.
Efficiently Manage Data
Integrate workflow data from JSON into your custom applications without relying on additional software. This empowers end-users to manage data more efficiently and gain better insights.
Connect to JSON from Any Platform
The JSON .NET connector is built against .NET Standard from the ground up–making it supported across Windows, Mac, Linux, and mobile device platforms. Connect to online data sources from your desktop, web, and mobile applications.
ADO.NET, Entity Framework Core, and LINQ Support
Connect to JSON data sources using standard ADO.NET objects and Entity Framework Core. The data connector uses ADO.NET objects like C1JsonConnection, C1JsonCommand, and C1JsonDataAdapter to make it easy to set up a connection. It also has in-built support for LINQ for native .NET data queries.
OpenAuth Authentication Support
The JSON .NET data connector supports OpenAuth-based authentication to help protect data through a secure connection. OpenAuth provides an open-standard authorization protocol or framework that describes how unrelated servers and services safely allow authenticated access to their assets, without sharing the initial, related, single login credential.
SQL Query Support
Query against JSON data sets using standard SQL syntax. The JSON C# data connector supports most SQL functionalities, including joining queries, functions, and summaries. Note that the first release only supports select queries.
Fast Cache with Incremental Updates
Improve performance over time with built-in caching and incremental updates. The data connector has in-built caching to support the local availability of data for faster performance on repeat operations. It also supports incremental updates so that only new or modified records sync to the cache. This improves performance over time because your app does not need to perform a complete refresh to update the cache. You can set the cache settings in the connection object to configure the cache database.
Scaffolding
Scaffolding is a reverse engineering technique that helps users quickly generate model classes based on the entities of your JSON data set. 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 scaffolding engine will generate model classes and a database context for Entity Framework Core.
The JSON .NET C# data connector focuses on connecting and querying, but users can use other .NET Standard and .NET Framework components to do even more.