.NET Connector for QuickBooks Online With ORM Support
dotConnect for QuickBooks Online is a versatile enterprise-grade connector that enables access to QuickBooks data in .NET applications of all levels. It delivers advanced ORM support, broad compatibility with .NET platforms, and easy integration with multiple IDEs, including Microsoft Visual Studio.
Moreover, this connector regularly undergoes security and performance tests to make sure it stays ahead of the competition at all times. Extra benefits include premium support, frequent updates, and detailed documentation to help you with a quick and easy start.
- Access to data with no need for any client libraries
- Advanced ORM support: EF Core, Dapper, NHibernate, and more
- Full compliance with ADO.NET standards
- Support for all versions of QuickBooks API
- Support for QuickBooks-specific features
- Powerful local SQL engine with support for SQL-92
- Integration with Visual Studio
Easy integration with QuickBooks Online
Integrate QuickBooks Online into your .NET applications through the standard ADO.NET interface.
No need to use an overcomplicated API
You don't have to study and use the QuickBooks Online API. SQL queries will make data retrieval much easier.
User-friendly ADO.NET classes
Get started quickly with the familiar ADO.NET classes used by dotConnect for QuickBooks Online.
using Devart.Data.QuickBooks;
class Program
{
static void Main()
{
using QuickBooksConnection conn = new(
"Authentication Type=OAuthInteractive;" +
"License Key=**********");
conn.Open();
}
}using Devart.Data.QuickBooks;
class Program
{
static void Main()
{
using QuickBooksConnection conn = new(
"Authentication Type=OAuthInteractive;" +
"Client Id=YOUR_CLIENT_ID;" +
"Client Secret=YOUR_CLIENT_SECRET;" +
"License Key=**********");
conn.Open();
}
}Easy connection to QuickBooks Online
dotConnect for QuickBooks Online, first and foremost, provides easy connection to QuickBooks and quick access to its data, required for integration with your applications.
- Easy connection that does not require any other libraries
- Full support for SQL queries and API calls
- Reliable security via advanced encryption and authentication
- Flexible connectivity options for diverse operational environments
- Cost-effective deployment
Advanced ORM support
dotConnect for QuickBooks Online offers enhanced ORM support with a bundled Entity Developer – visual designer for ORM models:
Entity Framework Core
1-10
NHibernate
1.x-5.x
Entity Framework
v4-v6
Dapper
1.x, 2.x
The use of Entity Developer alongside these ORM technologies enables the automatic creation of entity classes and the DbContext class.
Compatibility and integration
Platforms
- .NET 5.0, 6.0, 7.0, 8.0, 9.0, 10.0
- .NET Framework 4.5-4.8
- .NET Core 2.x-3.1
- ASP.NET Core Blazor
- .NET MAUI
QuickBooks Online API
All versions
Visual Studio Extension
- Data source connection
- Database object explorer
- Data retrieval and display
Compatibility with NuGet
Works in any NuGet-compatible IDE like VS Code, JetBrains Rider, etc.
Single connector for any SQL queries
dotConnect for QuickBooks Online brings the power of SQL to make your data management extremely simple — you can write and run SQL queries directly against the QuickBooks data. Just give it a go and see for yourself.
- Data management via SQL queries: SQL, being the foundation for the majority of modern database management systems, is the perfect language for variegated operations with all kinds of data.
- Full CRUD support: It is easy to perform CREATE, READ, UPDATE, and DELETE operations of any complexity using standard SQL statements.
- Advanced SQL capabilities: You can get more precise and profound insights by using JOINs, WHERE conditions, and other features of SQL.
- Broad object access: SQL queries will help you work with QuickBooks Online accounts, contacts, leads, contracts, products, campaigns, opportunities, and other objects.
How dotConnect for QuickBooks Online works
Simple queries are directly compiled into QuickBooks API calls and executed on the QuickBooks side.
Complex queries are divided into parts, with portions executed on QuickBooks, while the local SQL engine processes the results.
The processed data is returned to the application.
More articles
Connecting to QuickBooks Online
The tutorial describes how to connect to Mailchimp either at design-time, or from application code at run-time via QuickBooksConnection.
Retrieving QuickBooks Online Data
Once you have established a connection, you can learn how to use QuickBooksCommand, QuickBooksDataReader, and QuickBooksDataAdapter components in order to retrieve data from QuickBooks Online.
Updating QuickBooks Online Data
You can just as well update your data in QuickBooks—either by modifying data returned by the QuickBooksDataAdapter class or by executing corresponding DML statements via QuickBooksCommand.