IDataContextOptions.DelimitIdentifier Property

.NET Standard 2.x

Specifies whether to enclose the names of tables, columns, indexes, and constraints in double quotes when the SQL statement is generated.

Namespace: SnapObjects.Data

Assembly: SnapObjects.Data.dll

Syntax

bool DelimitIdentifier { get; set; }

Property Value

System.Boolean

Specifies whether to enclose table and column names in double quotes.

True -- to use double quotes.

False (default) -- not to use double quotes.

Remarks

This property influences:

• the generation of SQL statements; Raw SQL statements (e.g., non-PBSELECT statements in the DataWindow, and SQLBuildRaw used in SnapObjects programming) don't support the generation of DelimitIdentifier. The DelimitIdentifier used by SA varies, depending on the database types. For example, [] is used for the SQLServer database type; "" for the Oracle and PostGreSql database types; and '' for the MySql and Sqlite database types. The default value for the DelimitIdentifier property also varies across different database types. DelimitIdentifier defaults to true for the SqlServer database type and false for the Oracle, PostGreSql, MySql, and Sqlite database types.
• the text in double quotes; Only for the SqlServer database type, SA will treat the text in double quotes as a string when the DelimitIdentifier property is set to false.

Applies to

.NET Standard

2.x