dotConnect for Zoho Books Documentation
Devart.Data Namespace / SqlShimCommand Class / LocalSQLEngine Property

In This Topic
    LocalSQLEngine Property (SqlShimCommand)
    In This Topic
    Determines whether to use local SQL engine for SELECT queries, that are too complex to translate them directly to Zoho Books API calls or to throw an exception.
    Syntax
    'Declaration
     
    Public Property LocalSQLEngine As Boolean
    public bool LocalSQLEngine {get; set;}

    Property Value

    true, if queries, that are too complex to convert them to Zoho Books API calls and run on the Zoho Books side should be executed via local SQL engine by this Command; 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 property to false and run a query, using not supported features, via this command 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