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

Using the OneDriveDataReader

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

C#

string connectionString = "InitiateOAuth=GETANDREFRESH;OAuthClientId=MyApplicationId;OAuthClientSecret=MySecretKey;CallbackURL=http://localhost:33333;";

using (OneDriveConnection connection = new OneDriveConnection(connectionString)) {
  OneDriveCommand cmd = new OneDriveCommand("SELECT * FROM Files", connection);
  
  OneDriveDataReader rdr = cmd.ExecuteReader();

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

VB.NET

Dim connectionString As String = "InitiateOAuth=GETANDREFRESH;OAuthClientId=MyApplicationId;OAuthClientSecret=MySecretKey;CallbackURL=http://localhost:33333;"

Using connection As New OneDriveConnection(connectionString)
  Dim cmd As New OneDriveCommand("SELECT * FROM Files", connection)

  Dim rdr As OneDriveDataReader = cmd.ExecuteReader()

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