SQL Escape Sequences for .NET

How to Implement DBMS-specific Syntax

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:

The escape sequence used by .NET is:

{extension} 

The escape sequence is recognized and parsed by the Pervasive.SQL data provider, which replaces the escape sequences with data store-specific grammar. This section is divided into the following topics: