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

Using the AdobeAnalyticsDataReader

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

C#

string connectionString = "InitiateOAuth=GETANDREFRESH;";

using (AdobeAnalyticsConnection connection = new AdobeAnalyticsConnection(connectionString)) {
  AdobeAnalyticsCommand cmd = new AdobeAnalyticsCommand("SELECT * FROM SampleTable_1", connection);
  
  AdobeAnalyticsDataReader rdr = cmd.ExecuteReader();

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

VB.NET

Dim connectionString As String = "InitiateOAuth=GETANDREFRESH;"

Using connection As New AdobeAnalyticsConnection(connectionString)
  Dim cmd As New AdobeAnalyticsCommand("SELECT * FROM SampleTable_1", connection)

  Dim rdr As AdobeAnalyticsDataReader = cmd.ExecuteReader()

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