dotConnect for FreshBooks is an ADO.NET provider for working with FreshBooks data through the standard ADO.NET or Entity Framework interfaces. It allows you to easily integrate FreshBooks data into your .NET applications, and integrate FreshBooks services with widely used data-oriented technologies.
dotConnect for FreshBooks 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.
Connecting to FreshBooks from Server Explorer
1. Click Connect to Database on the Server Explorer toolbar
FreshBooks Data Binding
Power of SQL
dotConnect for FreshBooks allows you to perform SQL queries against your FreshBooks data. Use SQL statements to work with FreshBooks accounts, contacts, leads, contracts, products, campaigns opportunities, and other objects.
Our provider offers full CRUD (Create, Read, Update, and Delete) support and allows you to get FreshBooks data with SELECT statements and manage data with INSERT, UPDATE, and DELETE statements.
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.
Entity Framework Support
dotConnect for FreshBooks provides enhanced Entity Framework support for FreshBooks data with a bundled visual designer for ORM models with Visual Studio integration - Entity Developer. Standard Visual Studio Entity Data Model designer is also supported.