The CData ADO.NET Provider for Wave Financial implements two ADO.NET interfaces you can use to retrieve data from Wave Financial: WaveFinancialDataAdapter and WaveFinancialDataReader objects. Whereas WaveFinancialDataAdapter objects retrieve a single result set of all the data that matches a query, WaveFinancialDataReader objects fetch data in subset increments as needed.

Using the WaveFinancialDataReader

The WaveFinancialDataReader retrieves data faster than the WaveFinancialDataAdapter because it can retrieve data in pages. As you read data from the WaveFinancialDataReader, it periodically requests the next page of results from the data source, if required. This causes results to be returned at a faster rate. The following example selects all the columns from the Invoices table:

C#

string connectionString = "InitiateOAuth=GETANDREFRESH;";

using (WaveFinancialConnection connection = new WaveFinancialConnection(connectionString)) {
  WaveFinancialCommand cmd = new WaveFinancialCommand("SELECT * FROM Invoices", connection);
  
  WaveFinancialDataReader rdr = cmd.ExecuteReader();

  while (rdr.Read()) {
    Console.WriteLine(String.Format("\t{0} --> \t\t{1}", rdr["Id"], rdr["DueDate"]));
  }
}

VB.NET

Dim connectionString As String = "InitiateOAuth=GETANDREFRESH;"

Using connection As New WaveFinancialConnection(connectionString)
  Dim cmd As New WaveFinancialCommand("SELECT * FROM Invoices", connection)

  Dim rdr As WaveFinancialDataReader = cmd.ExecuteReader()

  While rdr.Read()
    Console.WriteLine([String].Format(vbTab & "{0} --> " & vbTab & vbTab & "{1}", rdr("Id"), rdr("DueDate")))
  End While
End Using