ADO.NET Provider for FreshBooks

Build 20.0.7587

Tables

The Tables schema collection lists all tables in the database, including views.

Retrieving the Table Listing

To retrieve the Tables schema collection, call the GetSchema method of the FreshBooksConnection class.

C#

String connectionString = "InitiateOAuth=GETANDREFRESH;OAuthClientId=MyClientId;OAuthClientSecret=MyClientSecret;CallbackURL=http://localhost:33333";

using (FreshBooksConnection conn = new FreshBooksConnection(connectionString)) {
  conn.Open();
  DataTable databaseSchema = conn.GetSchema("Tables");
  foreach (DataRow row in databaseSchema.Rows) {
    Console.WriteLine(row["TABLE_NAME"]);
  }
}

VB.NET

Dim connectionString As String = "InitiateOAuth=GETANDREFRESH;OAuthClientId=MyClientId;OAuthClientSecret=MyClientSecret;CallbackURL=http://localhost:33333"

Using conn As New FreshBooksConnection(connectionString)
  conn.Open()
  Dim databaseSchema As DataTable = conn.GetSchema("Tables")
  For Each row As DataRow In databaseSchema.Rows
    Console.WriteLine(row("TABLE_NAME"))
  Next
End Using

Columns Returned

The Tables schema collection returns the following columns.

Column NameData TypeDescription
TABLE_CATALOGSystem.StringThe database that contains the table.
TABLE_SCHEMASystem.StringThe schema that contains the table.
TABLE_NAMESystem.StringThe table name.
TABLE_TYPESystem.StringThe table type.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7587