This section describes how dotConnect for BigCommerce selects data.

• Retrieving Data
  

  This topic shows a simple example of getting BigCommerce data with dotConnect for BigCommerce.

• Select Statement Execution
  

  This topic explains how dotConnect for BigCommerce selects data.

• SQL Translation
  

  This topics contains the requirements to a SQL Statement, that can be translated to API calls.

• Temporary Cache
  

  This topics describes how dotConnect for BigCommerce uses temporary cache when a SELECT statement is executed locally.

• Counting API Calls
  

  This topics describes how dotConnect for BigCommerce uses temporary cache when a SELECT statement is executed locally.