A QuickBooks Online .NET data connector for cross-platform data integration and management.
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.
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.
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.
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.