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

Using the OracleHCMDataReader

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

C#

string connectionString = "Url=https://abc.oraclecloud.com;User=user;Password=password;";

using (OracleHCMConnection connection = new OracleHCMConnection(connectionString)) {
  OracleHCMCommand cmd = new OracleHCMCommand("SELECT * FROM RecruitingCESites", connection);
  
  OracleHCMDataReader rdr = cmd.ExecuteReader();

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

VB.NET

Dim connectionString As String = "Url=https://abc.oraclecloud.com;User=user;Password=password;"

Using connection As New OracleHCMConnection(connectionString)
  Dim cmd As New OracleHCMCommand("SELECT * FROM RecruitingCESites", connection)

  Dim rdr As OracleHCMDataReader = cmd.ExecuteReader()

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