Devart.Data.FreshBooks 3.2.100

Advanced C# Connection Provider for FreshBooks

dotConnect for FreshBooks is a versatile enterprise-grade ADO.NET data provider that enables .NET applications to access FreshBooks data using standard SQL statements—without requiring any client software or in-depth knowledge of the FreshBooks API.

The provider works with .NET Frameworks, .NET Core, .NET.

It implements the full range of standard ADO.NET interfaces (FreshBooksConnection, FreshBooksCommand, FreshBooksDataAdapter, FreshBooksDataReader) and is compatible with ORM frameworks including Entity Framework Core, NHibernate, and Dapper.

More information at dotConnect for FreshBooks.

Installation

1. Install the NuGet Package

Install-Package Devart.Data.FreshBooks

2. Activate license

• Free Trial License: Evaluate the full capabilities of dotConnect for FreshBooks in a non-commercial environment—ideal for development and testing. Start your free trial
• Commercial License: Deploy dotConnect for FreshBooks in commercial applications and access full technical support with a valid license. Purchase a license

Work with EF Core

For projects using Entity Framework Core with FreshBooks, install the Devart.Data.FreshBooks.EFCore package.

Compatibility

The following table show which version of this package to use with which version of frameworks.

More information here

Key Features

• SQL-Based Access: Execute familiar SQL queries (SELECT, INSERT, UPDATE, DELETE) directly on FreshBooks data—no need to study complex FreshBooks API endpoints.
• Full ADO.NET Compatibility: Implements standard ADO.NET interfaces including FreshBooksConnection, FreshBooksCommand, FreshBooksDataAdapter, and FreshBooksDataReader for seamless .NET integration.
• ORM Support: Compatible with Entity Framework Core, NHibernate, and Dapper, allowing use of your preferred data-access framework.
• Local SQL Engine: Supports SQL-92 standard with complex JOINs, WHERE conditions, and aggregations processed locally when the server does not support them.
• Advanced Security: Regular security audits and encrypted OAuth-based communication ensure safe access to your FreshBooks account data.
• Broad Platform Compatibility: Fully supports .NET Framework, .NET Core, .NET, ASP.NET Core, Blazor, and .NET MAUI.
• Visual Studio Integration: Connect to FreshBooks data directly from Visual Studio's data source tools and database explorer.
• Priority Support and Continuous Improvement: Backed by dedicated technical support and regular updates that deliver security enhancements, feature improvements, and long-term stability.

Usage

To help you get started quickly, here's a simple code example demonstrating how to connect to FreshBooks.

using Devart.Data.FreshBooks;

namespace FreshBooksConsoleApp
{
    class Program
    {
        static void Main(string[] args)
        {
            string connectionString = "Authentication Type=OAuthInteractive;Company Name=TestCompany;License key=**********";

            try
            {
                using (FreshBooksConnection connection = new FreshBooksConnection(connectionString))
                {
                    connection.Open();
                    Console.WriteLine("Connection successful.");
                }
            }
            catch (Exception ex)
            {
                Console.WriteLine("An error occurred: " + ex.Message);
            }
        }

    }
}

Basic Connection Strings

For more detailed tutorials, API reference, and advanced examples, visit our Getting Started guide.

Related Packages

• Devart.Data.FreshBooks.EFCore

Support Area

• Documentation
• Request form
• Feedback page
• Product history