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

Using the CventDataReader

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

C#

string connectionString = "InitiateOAuth=GETANDREFRESH;OAuthClientId=MyOAuthClientId;OAuthClientSecret=MyOAuthClientSecret;";

using (CventConnection connection = new CventConnection(connectionString)) {
  CventCommand cmd = new CventCommand("SELECT * FROM Events", connection);
  
  CventDataReader rdr = cmd.ExecuteReader();

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

VB.NET

Dim connectionString As String = "InitiateOAuth=GETANDREFRESH;OAuthClientId=MyOAuthClientId;OAuthClientSecret=MyOAuthClientSecret;"

Using connection As New CventConnection(connectionString)
  Dim cmd As New CventCommand("SELECT * FROM Events", connection)

  Dim rdr As CventDataReader = cmd.ExecuteReader()

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