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

Using the AzureDevOpsDataReader

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

C#

string connectionString = "AuthScheme=Basic;Organization=MyAzureDevOpsOrganization;Catalog=Project_dev;Schema=Project;PersonalAccessToken=MyPAT;";

using (AzureDevOpsConnection connection = new AzureDevOpsConnection(connectionString)) {
  AzureDevOpsCommand cmd = new AzureDevOpsCommand("SELECT * FROM WorkItems", connection);
  
  AzureDevOpsDataReader rdr = cmd.ExecuteReader();

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

VB.NET

Dim connectionString As String = "AuthScheme=Basic;Organization=MyAzureDevOpsOrganization;Catalog=Project_dev;Schema=Project;PersonalAccessToken=MyPAT;"

Using connection As New AzureDevOpsConnection(connectionString)
  Dim cmd As New AzureDevOpsCommand("SELECT * FROM WorkItems", connection)

  Dim rdr As AzureDevOpsDataReader = cmd.ExecuteReader()

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