This section describes how dotConnect for Magento selects data.

• Retrieving Data
  

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

• Select Statement Execution
  

  This topic explains how dotConnect for Magento 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 Magento uses temporary cache when a SELECT statement is executed locally.