dotConnect for Dynamics 365 Documentation
Devart.Data Namespace / SqlShimConnectionStringBuilder Class / LocalSQLEngine Property

LocalSQLEngine Property (SqlShimConnectionStringBuilder)
Determines whether to use local SQL engine for SELECT queries, that are too complex to translate them directly to Dynamics 365 API calls or to throw an exception.
Syntax
'Declaration
 
Public Property LocalSQLEngine As Boolean
 

Property Value

true, if queries, that are too complex to convert them to Dynamics 365 API calls and run on the Dynamics 365 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

See Also