Querying with the DataReader
The CData ADO.NET Provider for BigCommerce implements two ADO.NET interfaces you can use to retrieve data from BigCommerce: BigCommerceDataAdapter and BigCommerceDataReader objects. Whereas BigCommerceDataAdapter objects retrieve a single result set of all the data that matches a query, BigCommerceDataReader objects fetch data in subset increments as needed.
Using the BigCommerceDataReader
The BigCommerceDataReader retrieves data faster than the BigCommerceDataAdapter because it can retrieve data in pages. As you read data from the BigCommerceDataReader, 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 Customers table:
C#
string connectionString = "AuthScheme=OAuth;InitiateOAuth=GETANDREFRESH;OAuthClientId=YourClientId;OAuthClientSecret=YourClientSecret;StoreId='YoUrSToREId';CallbackURL='http://localhost:33333'"; using (BigCommerceConnection connection = new BigCommerceConnection(connectionString)) { BigCommerceCommand cmd = new BigCommerceCommand("SELECT * FROM Customers", connection); BigCommerceDataReader rdr = cmd.ExecuteReader(); while (rdr.Read()) { Console.WriteLine(String.Format("\t{0} --> \t\t{1}", rdr["FirstName"], rdr["LastName"])); } }
VB.NET
Dim connectionString As String = "AuthScheme=OAuth;InitiateOAuth=GETANDREFRESH;OAuthClientId=YourClientId;OAuthClientSecret=YourClientSecret;StoreId='YoUrSToREId';CallbackURL='http://localhost:33333'" Using connection As New BigCommerceConnection(connectionString) Dim cmd As New BigCommerceCommand("SELECT * FROM Customers", connection) Dim rdr As BigCommerceDataReader = cmd.ExecuteReader() While rdr.Read() Console.WriteLine([String].Format(vbTab & "{0} --> " & vbTab & vbTab & "{1}", rdr("FirstName"), rdr("LastName"))) End While End Using