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

Using the AnaplanDataReader

The AnaplanDataReader retrieves data faster than the AnaplanDataAdapter because it can retrieve data in pages. As you read data from the AnaplanDataReader, 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 [Workspace].[Model].[Sales] table:

C#

string connectionString = "AuthScheme=Basic;[email protected];Password=password;";

using (AnaplanConnection connection = new AnaplanConnection(connectionString)) {
  AnaplanCommand cmd = new AnaplanCommand("SELECT * FROM [Workspace].[Model].[Sales]", connection);
  
  AnaplanDataReader rdr = cmd.ExecuteReader();

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

VB.NET

Dim connectionString As String = "AuthScheme=Basic;[email protected];Password=password;"

Using connection As New AnaplanConnection(connectionString)
  Dim cmd As New AnaplanCommand("SELECT * FROM [Workspace].[Model].[Sales]", connection)

  Dim rdr As AnaplanDataReader = cmd.ExecuteReader()

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