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

Using the OneNoteDataReader

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

C#

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

using (OneNoteConnection connection = new OneNoteConnection(connectionString)) {
  OneNoteCommand cmd = new OneNoteCommand("SELECT * FROM Notebooks", connection);
  
  OneNoteDataReader rdr = cmd.ExecuteReader();

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

VB.NET

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

Using connection As New OneNoteConnection(connectionString)
  Dim cmd As New OneNoteCommand("SELECT * FROM Notebooks", connection)

  Dim rdr As OneNoteDataReader = cmd.ExecuteReader()

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