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

Using the AsanaDataReader

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

C#

string connectionString = "InitiateOAuth=GETANDREFRESH;OAuthClientId=YourClientId;OAuthClientSecret=YourClientSecret;CallbackURL='http://localhost:33333'";

using (AsanaConnection connection = new AsanaConnection(connectionString)) {
  AsanaCommand cmd = new AsanaCommand("SELECT * FROM projects", connection);
  
  AsanaDataReader rdr = cmd.ExecuteReader();

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

VB.NET

Dim connectionString As String = "InitiateOAuth=GETANDREFRESH;OAuthClientId=YourClientId;OAuthClientSecret=YourClientSecret;CallbackURL='http://localhost:33333'"

Using connection As New AsanaConnection(connectionString)
  Dim cmd As New AsanaCommand("SELECT * FROM projects", connection)

  Dim rdr As AsanaDataReader = cmd.ExecuteReader()

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