Using SQL Escape Sequences in .NET Applications

A number of language features, such as outer joins and scalar function calls, are commonly implemented by DBMSs. The syntax for these features is often DBMS-specific, even when a standard syntax has been defined. The DataDirect Connect for ADO.NET data providers support escape sequences that contain standard syntaxes for the following language features:

• Date, time, and timestamp literals
• Scalar functions such as numeric, string, and data type conversion functions
• Stored procedures
• Outer joins
• SQL extension

The data providers recognize and parse the escape sequence, replacing the escape sequences with data store-specific grammar.