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

Using the GoogleAdsDataReader

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

C#

string connectionString = "InitiateOAuth=GETANDREFRESH;DeveloperToken=myDeveloperToken;ClientCustomerId=myClientCustomerId;";

using (GoogleAdsConnection connection = new GoogleAdsConnection(connectionString)) {
  GoogleAdsCommand cmd = new GoogleAdsCommand("SELECT * FROM CampaignPerformance", connection);
  
  GoogleAdsDataReader rdr = cmd.ExecuteReader();

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

VB.NET

Dim connectionString As String = "InitiateOAuth=GETANDREFRESH;DeveloperToken=myDeveloperToken;ClientCustomerId=myClientCustomerId;"

Using connection As New GoogleAdsConnection(connectionString)
  Dim cmd As New GoogleAdsCommand("SELECT * FROM CampaignPerformance", connection)

  Dim rdr As GoogleAdsDataReader = cmd.ExecuteReader()

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