LocalSQLEngine Property (SqlShimConnectionStringBuilder)

In This Topic

Determines whether to use local SQL engine for SELECT queries, that are too complex to translate them directly to BigCommerce API calls or to throw an exception.

Syntax

Visual Basic
C#

'Declaration
 
Public Property LocalSQLEngine As Boolean

public bool LocalSQLEngine {get; set;}

Property Value

true, if queries, that are too complex to convert them to BigCommerce API calls and run on the BigCommerce side should be executed via local SQL engine; otherwise, false. Default value is true.

Remarks

For the list of query features, supported without using local SQL engine, see SQL Translation. If you set this connection string parameter to false and run a query, using not supported features, you will get an exception: "Select statement cannot be directly executed by service".

Please note, however, that if you use local SQL engine, and a query requires it to run, all the data from the tables, mentioned in the query, is loaded to the local cache. If this is a lot of data, and you prefer rather to get an exception than to load huge volumes of data to local cache, set this parameter to true.

Requirements

Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

Reference

SqlShimConnectionStringBuilder Class
SqlShimConnectionStringBuilder Members

Send Feedback