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

Using the WooCommerceDataReader

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

C#

string connectionString = " Url=http://localhost/woocommerce/;ConsumerKey=ck_ec52c76185c088ecaa3145287c8acba55a6f59ad;ConsumerSecret=cs_9fde14bf57126156701a7563fc87575713c355e5;";

using (WooCommerceConnection connection = new WooCommerceConnection(connectionString)) {
  WooCommerceCommand cmd = new WooCommerceCommand("SELECT * FROM Orders", connection);
  
  WooCommerceDataReader rdr = cmd.ExecuteReader();

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

VB.NET

Dim connectionString As String = " Url=http://localhost/woocommerce/;ConsumerKey=ck_ec52c76185c088ecaa3145287c8acba55a6f59ad;ConsumerSecret=cs_9fde14bf57126156701a7563fc87575713c355e5;"

Using connection As New WooCommerceConnection(connectionString)
  Dim cmd As New WooCommerceCommand("SELECT * FROM Orders", connection)

  Dim rdr As WooCommerceDataReader = cmd.ExecuteReader()

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