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

Using the GitHubDataReader

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

C#

string connectionString = "InitiateOAuth=GETANDREFRESH;OAuthClientId=MyOAuthClientId;OAuthClientSecret=MyOAuthClientSecret;CallbackURL=http://localhost:portNumber";

using (GitHubConnection connection = new GitHubConnection(connectionString)) {
  GitHubCommand cmd = new GitHubCommand("SELECT * FROM Repositories", connection);
  
  GitHubDataReader rdr = cmd.ExecuteReader();

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

VB.NET

Dim connectionString As String = "InitiateOAuth=GETANDREFRESH;OAuthClientId=MyOAuthClientId;OAuthClientSecret=MyOAuthClientSecret;CallbackURL=http://localhost:portNumber"

Using connection As New GitHubConnection(connectionString)
  Dim cmd As New GitHubCommand("SELECT * FROM Repositories", connection)

  Dim rdr As GitHubDataReader = cmd.ExecuteReader()

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