Supported SQL

The RSSBus Salesforce ADO.NET Provider supports several basic operations on data, including querying, deleting, modifying, and inserting. These operations are performed using SQL that is close to standard SQL, but may have minor differences described here.

Note: SQL statements are not used by the RSSBus Salesforce ADO.NET Provider when invoking Stored Procedures, so there is no SQL keyword equivalent to the EXEC keyword in T-SQL or other database tools. To execute Stored Procedures, explicitly set the CommandType property of the Command object to CommandType.StoredProcedure.

The RSSBus Salesforce ADO.NET Provider does not support batching of SQL statements. To execute multiple commands, create multiple instances of the SalesForceCommand object and execute each separately.

SELECT Statements

SELECT statements generally follow the standard SQL Syntax. For more information and specific examples, see SELECT Statements.

UPDATE Statements

UPDATE statements generally follow the standard SQL Syntax, but the RSSBus Salesforce ADO.NET Provider supports updating only one row at a time. Hence the primary key Id is always required. For more information and specific examples, see UPDATE Statements.

INSERT Statements

INSERT statements generally follow the standard SQL Syntax. For more information and specific examples, see INSERT Statements.

DELETE Statements

DELETE statements generally follow the standard SQL Syntax, but the RSSBus Salesforce ADO.NET Provider supports deleting only one row at a time. Hence the primary key Id is always required. For more information and specific examples, see DELETE Statements.

CACHE Statements

Cache statements allow you to have direct control over the cached data. The CacheLocation must be specified in order to use cache statements. For more information and specific examples, see CACHE Statements.

Names and Quoting

• Table and column names are considered identifier names, and as such are restricted to characters [A-Za-z0-9_:@].
• To use a table or column name with characters not listed, the name must be quoted using square brackets ([name]) in any SQL statement.
• Parameter names start with the @ symbol (i.e. @p1, @CustomerName) and can not be quoted.
• Strings should be quoted using single quotes (i.e. 'John Doe').