The CData ADO.NET Provider for SAP Success Factors LMS implements two ADO.NET interfaces you can use to retrieve data from SAPSuccessFactorsLMS: SAPSuccessFactorsLMSDataAdapter and SAPSuccessFactorsLMSDataReader objects. Whereas SAPSuccessFactorsLMSDataAdapter objects retrieve a single result set of all the data that matches a query, SAPSuccessFactorsLMSDataReader objects fetch data in subset increments as needed.

Using the SAPSuccessFactorsLMSDataReader

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

C#

string connectionString = "User=username;UserType=Password;CompanyId=CompanyId;Url=https://api4.successfactors.com";

using (SAPSuccessFactorsLMSConnection connection = new SAPSuccessFactorsLMSConnection(connectionString)) {
  SAPSuccessFactorsLMSCommand cmd = new SAPSuccessFactorsLMSCommand("SELECT * FROM SampleTable_1", connection);
  
  SAPSuccessFactorsLMSDataReader rdr = cmd.ExecuteReader();

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

VB.NET

Dim connectionString As String = "User=username;UserType=Password;CompanyId=CompanyId;Url=https://api4.successfactors.com"

Using connection As New SAPSuccessFactorsLMSConnection(connectionString)
  Dim cmd As New SAPSuccessFactorsLMSCommand("SELECT * FROM SampleTable_1", connection)

  Dim rdr As SAPSuccessFactorsLMSDataReader = cmd.ExecuteReader()

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