The CData ADO.NET Provider for Salesforce Marketing Cloud Account Engagement implements two ADO.NET interfaces you can use to retrieve data from Salesforce Marketing Cloud Account Engagement: 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