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

Using the OracleEloquaDataReader

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

C#

string connectionString = "User=user;Password=password;Company=MyCompany";

using (OracleEloquaConnection connection = new OracleEloquaConnection(connectionString)) {
  OracleEloquaCommand cmd = new OracleEloquaCommand("SELECT * FROM Contact", connection);
  
  OracleEloquaDataReader rdr = cmd.ExecuteReader();

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

VB.NET

Dim connectionString As String = "User=user;Password=password;Company=MyCompany"

Using connection As New OracleEloquaConnection(connectionString)
  Dim cmd As New OracleEloquaCommand("SELECT * FROM Contact", connection)

  Dim rdr As OracleEloquaDataReader = cmd.ExecuteReader()

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