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

Using the VaultCRMDataReader

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

C#

string connectionString = "Url=myURL;User=myUser;Password=myPassword;";

using (VaultCRMConnection connection = new VaultCRMConnection(connectionString)) {
  VaultCRMCommand cmd = new VaultCRMCommand("SELECT * FROM Users", connection);
  
  VaultCRMDataReader rdr = cmd.ExecuteReader();

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

VB.NET

Dim connectionString As String = "Url=myURL;User=myUser;Password=myPassword;"

Using connection As New VaultCRMConnection(connectionString)
  Dim cmd As New VaultCRMCommand("SELECT * FROM Users", connection)

  Dim rdr As VaultCRMDataReader = cmd.ExecuteReader()

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