This section describes how dotConnect for SugarCRM selects data.

• Retrieving Data
  

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

• Select Statement Execution
  

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