ADO.NET Provider for Google Analytics

Build 20.0.7654

Querying with the DataReader

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

Using the GoogleAnalyticsDataReader

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

C#

string connectionString = "InitiateOAuth=GETANDREFRESH;Profile=myProfile;";

using (GoogleAnalyticsConnection connection = new GoogleAnalyticsConnection(connectionString)) {
  GoogleAnalyticsCommand cmd = new GoogleAnalyticsCommand("SELECT * FROM Traffic", connection);
  
  GoogleAnalyticsDataReader rdr = cmd.ExecuteReader();

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

VB.NET

Dim connectionString As String = "InitiateOAuth=GETANDREFRESH;Profile=myProfile;"

Using connection As New GoogleAnalyticsConnection(connectionString)
  Dim cmd As New GoogleAnalyticsCommand("SELECT * FROM Traffic", connection)

  Dim rdr As GoogleAnalyticsDataReader = cmd.ExecuteReader()

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

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