Property EscapeIdentifiers

Namespace

YndigoBlue.Velocity.Data.Oracle

Assembly

YndigoBlue.Velocity.dll

EscapeIdentifiers

Gets or sets whether Oracle identifiers (table names, column names) should be wrapped in double quotes. Only relevant when connecting to Oracle 19c or earlier. Defaults to true.

public bool EscapeIdentifiers { get; set; }

Property Value

bool

Remarks

When enabled, all identifiers are wrapped in double quotes (e.g. "my_table"). Oracle treats quoted identifiers as case-sensitive and exactly as written; unquoted identifiers are silently uppercased, which can cause schema mismatches with snake_case or mixed-case names.

Oracle 19c and earlier: Leave this at the default (true) unless all of your identifiers are uppercase and contain no reserved words or special characters. Disabling it on a schema that was created with quoted identifiers will cause every query and DDL statement to fail.

Oracle 23c and later: This setting has no effect and can be ignored — Oracle 23c no longer requires quoted identifiers for case-preserving behaviour.

warning

Do not disable this setting on Oracle 19c unless every identifier in your schema is uppercase, reserved-word-free, and contains no special characters.

Can also be set via SetContextSettings(string) using the key EscapeIdentifiers (e.g. "EscapeIdentifiers=false").