SQL Escape Sequences for .NET
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. .NET supports 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
•
Outer joins
The escape sequence used by .NET is:
{extension}
The escape sequence is recognized and parsed by the Pervasive PSQL ADO.NET Data Provider, which replaces the escape sequences with data store-specific grammar.