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

Using the SuiteCRMDataReader

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

C#

string connectionString = "URL=http://mySuiteCRM.com;User=myUser;Password=myPassword;";

using (SuiteCRMConnection connection = new SuiteCRMConnection(connectionString)) {
  SuiteCRMCommand cmd = new SuiteCRMCommand("SELECT * FROM Accounts", connection);
  
  SuiteCRMDataReader rdr = cmd.ExecuteReader();

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

VB.NET

Dim connectionString As String = "URL=http://mySuiteCRM.com;User=myUser;Password=myPassword;"

Using connection As New SuiteCRMConnection(connectionString)
  Dim cmd As New SuiteCRMCommand("SELECT * FROM Accounts", connection)

  Dim rdr As SuiteCRMDataReader = cmd.ExecuteReader()

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