QuickBooks Online .NET Data Connector - Integrate Financial Data into Your Apps

A QuickBooks Online .NET data connector for cross-platform data integration and management.

  • Import data from QuickBooks Online to analyze against data from other locations
  • Perform any operation against the Financial system, such as queries and updates
  • Quickly and easily display financial data or generate reports
  • Cross-platform .NET Standard support
Download Free Trial

Why Choose QuickBooks Online for Your .NET Applications?

Create Data-Oriented Apps Faster

QuickBooks Online .NET integration is made easy with fast and direct access to the cloud-based Financial system. The .NET QuickBooks Online data connector hides the complexity of connecting to QuickBooks Online and offers a unified interface for performing common operations against multiple data sources.

Manage Data More Efficiently

Integrate financial data from QuickBooks Online into your custom applications without relying on additional software. This empowers end-users to manage data more efficiently and, ultimately, gain better insights.

Connect to OData from Any Platform

The QuickBooks Online .NET API is built against .NET Standard from the ground up, so it's supported across Windows, Mac, Linux and mobile device platforms. Connect to QuickBooks Online from your desktop, web and mobile applications.

Data Features

ADO.NET, Entity Framework Core & LINQ Support

Connect to QuickBooks Online data using standard ADO.NET objects and Entity Framework Core. The data connector uses ADO.NET objects like C1QuickBooksOnlineConnection, C1QuickBooksOnlineCommand, and C1QuickBooksOnlineDataAdapter to make it easy to set up a connection. It also has in-built support for LINQ queries for native .NET data queries.

OpenAuth Authentication Support

The QuickBooks Online .NET data connector supports OpenAuth-based authentication to help you protect your data through a secure connection. OpenAuth provides an open-standard authorization protocol or framework that describes how unrelated servers and services can safely allow authenticated access to their assets without actually sharing the initial, related, single login credential.

SQL Query Support

Query against QuickBooks Online data using standard SQL syntax. The QuickBooks Online .NET C# data connector supports most SQL functionality including joins queries, functions, and summaries.

CRUD Operations

In addition to querying, the data connectors support other CRUD operations such as insertion, updating, and deleting data. The data connector supports these operations using Command and DataAdapter objects. Also, performance could be enhanced in these operations by using the Batch feature to submit changes in chunks over the network.

Fast Cache with Incremental Updates

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 the 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 QuickBooks Online 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.

More Data Integration Capabilities

While the QuickBooks Online .NET C# data connector focuses primarily on connecting and querying, you can use it alongside other .NET Standard and .NET Framework components to do a lot more.

  • Integrate QuickBooks Online data with C1DataCollection to provide filtering, grouping, data virtualization to your data-aware controls.
  • Import data from QuickBooks Online to C1DataEngine to analyze massive amounts of data in fractions of seconds.
  • Connect QuickBooks Online data to pivot grids & charts, such as FlexPivot, to analyze data visually.
  • Create business reports using FlexReport and QuickBooks Online for essential business tasks.
  • Display financial data from QuickBooks Online in a .NET FlexGrid control on desktop, web, or mobile devices.