A .NET Data Connectivity Library for JSON Data Sources

  • Import data from JSON sources to analyze against data from other locations
  • Authenticate and query against JSON sources
  • Seamlessly display data from the JSON sources in your .NET apps
  • Move data from JSON to other sources, including OData, Dynamics, Salesforce, and more
  • Cross-platform .NET Standard support
Download Free Trial

Why Choose JSON for Your .NET Applications?

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.

Data Features

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.

More Data Integration Capabilities

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.

  • Provide filtering, grouping, and data virtualization to your data-aware controls by integrating online data with C1DataCollection
  • Analyze massive amounts of data in seconds by importing records from JSON to C1DataEngine
  • Connect JSON data to pivot grids and charts, such as FlexPivot, to analyze data visually
  • Create business reports using FlexReport and JSON data for essential business tasks
  • Perform JSON data binding in a .NET FlexGrid control in desktop, web, or mobile devices