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

Using the PipedriveDataReader

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

C#

string connectionString = "AuthScheme=Basic;CompanyDomain=MyCompanyDomain;APIToken=MyAPIToken;";

using (PipedriveConnection connection = new PipedriveConnection(connectionString)) {
  PipedriveCommand cmd = new PipedriveCommand("SELECT * FROM Deals", connection);
  
  PipedriveDataReader rdr = cmd.ExecuteReader();

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

VB.NET

Dim connectionString As String = "AuthScheme=Basic;CompanyDomain=MyCompanyDomain;APIToken=MyAPIToken;"

Using connection As New PipedriveConnection(connectionString)
  Dim cmd As New PipedriveCommand("SELECT * FROM Deals", connection)

  Dim rdr As PipedriveDataReader = cmd.ExecuteReader()

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