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

Using the JiraServiceDeskDataReader

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

C#

string connectionString = "ApiKey=myApiKey;User=MyUser;InitiateOAuth=GETANDREFRESH;";

using (JiraServiceDeskConnection connection = new JiraServiceDeskConnection(connectionString)) {
  JiraServiceDeskCommand cmd = new JiraServiceDeskCommand("SELECT * FROM Requests", connection);
  
  JiraServiceDeskDataReader rdr = cmd.ExecuteReader();

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

VB.NET

Dim connectionString As String = "ApiKey=myApiKey;User=MyUser;InitiateOAuth=GETANDREFRESH;"

Using connection As New JiraServiceDeskConnection(connectionString)
  Dim cmd As New JiraServiceDeskCommand("SELECT * FROM Requests", connection)

  Dim rdr As JiraServiceDeskDataReader = cmd.ExecuteReader()

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