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

Using the FinancialForceDataReader

The FinancialForceDataReader retrieves data faster than the FinancialForceDataAdapter because it can retrieve data in pages. As you read data from the FinancialForceDataReader, 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 Account table:

C#

string connectionString = "User=myUser;Password=myPassword;Security Token=myToken;";

using (FinancialForceConnection connection = new FinancialForceConnection(connectionString)) {
  FinancialForceCommand cmd = new FinancialForceCommand("SELECT * FROM Account", connection);
  
  FinancialForceDataReader rdr = cmd.ExecuteReader();

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

VB.NET

Dim connectionString As String = "User=myUser;Password=myPassword;Security Token=myToken;"

Using connection As New FinancialForceConnection(connectionString)
  Dim cmd As New FinancialForceCommand("SELECT * FROM Account", connection)

  Dim rdr As FinancialForceDataReader = cmd.ExecuteReader()

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