ADO.NET Provider for Salesforce Pardot

Build 21.0.8137

Querying with the DataReader

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

Using the SalesforcePardotDataReader

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

C#

string connectionString = "InitiateOAuth=GETANDREFRESH;BusinessUnitID=YourBusinessId;";

using (SalesforcePardotConnection connection = new SalesforcePardotConnection(connectionString)) {
  SalesforcePardotCommand cmd = new SalesforcePardotCommand("SELECT * FROM Prospects", connection);
  
  SalesforcePardotDataReader rdr = cmd.ExecuteReader();

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

VB.NET

Dim connectionString As String = "InitiateOAuth=GETANDREFRESH;BusinessUnitID=YourBusinessId;"

Using connection As New SalesforcePardotConnection(connectionString)
  Dim cmd As New SalesforcePardotCommand("SELECT * FROM Prospects", connection)

  Dim rdr As SalesforcePardotDataReader = cmd.ExecuteReader()

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

Copyright (c) 2022 CData Software, Inc. - All rights reserved.
Build 21.0.8137