A cross-platform, data connectivity library for connecting to JSON data sets in your .NET applications.
The .NET JSON data connector is part of ComponentOne Data Services.
Download Free TrialCreate Data-Oriented Apps Faster
Get fast and direct access to JSON data sets with less of the complexity through a unified interface for querying against all supported data sources.
Manage Data More Efficiently
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 DataConnectors library is built against .NET Standard from the ground up so it's supported across Windows, Mac, Linux, and mobile device platforms.
With full Visual Studio 2019 and Visual Studio 2022 integration, you can quickly and easily connect to your JSON data sets. Connect to JSON files through the Server Explorer, without writing a single line of C# or VB.NET code, and then drag tables on the dataset designer, and connect data-aware controls like grids, charts and report designers.
ADO.NET and Entity Framework Core Support
Connect to JSON formatted data using standard ADO.NET objects and Entity Framework Core. The data connector uses ADO.NET objects to make it easy to set up a connection.
OAuth Authentication Support
The JSON data connector library supports the industry standard authentication protocol, OAuth 2.0, to help you protect your data through a secure connection.
SQL and LINQ Query Support
Query against JSON data using most standard SQL syntax including joins queries, functions, and summaries. It also has in-built support for LINQ queries for native .NET data queries.
Fetching and Pooling
The JSON data connector supports read-only fetching of data and it implements connection pooling to reduce the efforts of repeatedly opening and closing connections.
Caching and Streaming
Improve performance by using a local cache database for repeat operations or by streaming data rather than of loading everything to memory.
Scaffolding
With scaffolding support, the JSON data connector library can generate model classes and a database context for Entity Framework Core. The scaffolding command can be run from Visual Studio.
While the JSON .NET C# data connector focuses primarily on connecting and querying, you can use it alongside other .NET Standard and .NET Framework components to do much more.
Desktop DataConnectors Explorer
If you have a JSON data set URL you can explore it through our DataConnectors Explorer on Windows by downloading the desktop Demo Explorer.
OLAP Invoice Report
See how to connect to various data sources, including JSON, in this web demo for our cross-platform data connectivity library.