Page 1 of 1

Is sub queries supported in salesforce ado.net connector

Posted: Wed 04 Oct 2017 12:59
by tahiriqbal_pk
Is sub queries supported in salesforce ado.net connector
Including :
Column level sub query
Filter level sub query
Derived Table sub query

Re: Is sub queries supported in salesforce ado.net connector

Posted: Thu 05 Oct 2017 16:48
by Shalex
dotConnect for Salesforce works with SQL-92 compliant SELECT statements: https://www.devart.com/dotconnect/sales ... ement.html.

Local cache is an SQLite database, so please use SQLite compliant SQL (NOT Transact-SQL): https://www.sqlite.org/lang_select.html.