Skip to main content Skip to footer
Data Connectivity Library

Connect to the Most Popular .NET Data Sources

ComponentOne DataConnectors is a collection of .NET components for connecting to and performing any data operation, such as queries and updates, against a variety of popular data sources.

  • Import and analyze data from different data sources using a common interface
  • Connect using familiar ADO.NET or Entity Framework technologies
  • Combine data from the most popular data sources including Microsoft Dynamics 365, Salesforce, QuickBooks Online, Google Analytics, Snowflake and more
  • Use the components across any .NET framework or platform

ComponentOne DataConnectors are available with Studio Enterprise, WinForms Data Services Edition, or Data Services Edition.

Download Free Trial

Overview

.NET Data Connector components are reusable libraries that help developers connect to a wide variety of data sources in their .NET applications in less time. ComponentOne provides a complete set of high-performing data connector components for popular data formats and online CRMs.

Why Choose ComponentOne DataConnectors?

Quickly Style Apps

Create Data-Oriented Apps Faster

Our .NET data connectors provide fast and direct access to a variety of data sources, hiding the complexity with a unified interface for querying and updating multiple sources.

Increase Productivity

Manage Data More Efficiently

Integrate data from various sources into your business applications and empower your users to manage data more efficiently without relying on additional software.

Cross Platform Chart

Connect to Data from Any Platform

ComponentOne DataConnectors is built against .NET Standard from the ground up so it's supported across all Windows, Mac, Linux, and mobile device platforms.

Supported .NET Data Sources

Additional .NET Data Sources

OData

A cross-platform, data connectivity library for connecting to any OData data source.

Learn More

JSON

Connect to any JSON data source using ADO.NET. Query JSON data using SQL or LINQ.

Learn More

CSV

Connect to CSV files quickly and easily through C# code and Visual Studio.

Learn More

Visual Studio Integration

Quickly and easily connect to any of the supported data sources through Visual Studio 2019 or 2022. You can connect to these sources through the Server Explorer, without writing a single line of code, and then drag and drop tables on the dataset designer, and connect data-aware controls like grids, charts & report designers.

Data Features

ADO.NET and Entity Framework Core Support

Connect to online data sources 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. 

OpenAuth and Proxy Authentication

The data connectors support the industry standard open authentication protocol, OpenAuth 2.0, to help you protect data through a secure connection. The connectors also support Basic, Digest and Kerberos proxy authentication.

SQL and LINQ Query Support

Query against the data source 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.

Batch CRUD Operations

The data connectors support CRUD operations such as inserting, updating and deleting data through Command and DataAdapter objects. You can further optimize network performance by performing batch updates.

Fast Cache with Incremental Updates

With built-in caching you can improve performance by using a local cache database for repeat operations. It also supports incremental updates so that only new or modified records get synced to the cache.

Scaffolding

With scaffolding support, the data connector library can generate model classes and a database context for Entity Framework Core. The scaffolding command can be run from Visual Studio.

Logging

Collect data about the connection by logging each execution. You can control the level of details collected from logging only critical errors to every complete detail.

Fetching and Pooling

The .NET data connectors support fetching and connection pooling to reduce the efforts of repeatedly opening and closing connections.

More Data Integration Capabilities

While the data connectors focus primarily on connecting and querying, you can use them with other powerful .NET Standard and .NET Framework components to do a lot more.

  • Integrate data with DataCollection to provide filtering, grouping, data virtualization to your data-aware controls.
  • Import data and use DataEngine 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 data source.
  • Create business reports using FlexReport for important business tasks.
  • Display data in a .NET FlexGrid control on desktop, web, or mobile devices.