Devart.Data.FreshBooks 2.3.190

dotConnect for FreshBooks

dotConnect for FreshBooks is an ADO.NET provider for working with FreshBooks data through the standard ADO.NET interfaces. It allows you to easily integrate FreshBooks data into your .NET applications, and integrate FreshBooks services with widely used data-oriented technologies.

The provider works with .NET Frameworks 4.5+, .NET Core 2.0+, .NET 5+.

It has the same standard ADO.NET classes as other standard ADO.NET providers: FreshBooksConnection, FreshBooksCommand, FreshBooksDataAdapter, FreshBooksDataReader, FreshBooksParameter, etc. This allows you quickly get started with it and eliminates the need to study any FreshBooks data access specificities.

More information at dotConnect for FreshBooks.

Compatibility

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

More information here

Installation

For projects, using general ADO.NET functionality of dotConnect for FreshBooks, you need to install the Devart.Data.FreshBooks package. Execute the following command in the Package Manager Console:

Install-Package Devart.Data.FreshBooks

For projects, using Entity Framework Core 3, 5, 6, 7, 8, 9 with FreshBooks, install the Devart.Data.FreshBooks.EFCore package.

License

See pricing options for ordering.

To activate your license, please download dotConnect for FreshBooks from our website. This installer generates the trial key files required for using this package on a trial basis.

Usage

In this example, a new instance of the FreshBooksConnection class (part of the Devart.Data.FreshBooks namespace) is created.

freshbooksConnectionString = 
        "APIVersion=Alpha;AccessToken=***********;RefreshToken=***********;CompanyName=Test";

ASP.NET Core and Blazor

Configuration File Snippet (appsettings.json):

{
  "ConnectionStrings": {
    "DefaultConnection": "APIVersion=Alpha;AccessToken=***********;RefreshToken=***********;CompanyName=Test"
   }
}

Dependency Injection of IConfiguration:

private readonly IConfiguration configuration;

public YourController(IConfiguration config) 
{
    configuration = config;
}

Retrieving a Connection String:

var connectionString = configuration.GetConnectionString("DefaultConnection");
var connection = new FreshBooksConnection(connectionString);

Key Features

• Easy Connection: Allows your .NET application to work with FreshBooks data.
• SQL Engine: No need to study and use complex FreshBooks API, just use familiar SQL statements. You may use complex JOINs, WHERE conditions, etc. - all the SQL benefits, not available with FreshBooks API.
• Support and updates: Enjoy dedicated support team for prompt issue resolution and regular updates to keep your software running smoothly and securely.

Related Packages

• Devart.Data.FreshBooks.EFCore

Support Area

• Support
• Documentation
• Request form
• Feedback page
• Product history

More Resources

• Blog about dotConnect
• Devart Website