ComponentOne DataObjects for .NET
AlwaysEscapeNames Property (C1ExpressConnection)

C1.Data.Express.2 Assembly > C1.Data.Express Namespace > C1ExpressConnection Class : AlwaysEscapeNames Property
Gets or sets a value indicating whether every table and column name must be quoted to avoid collision with reserved keywords.
Syntax
'Declaration
 
Public Property AlwaysEscapeNames As System.Boolean
public System.bool AlwaysEscapeNames {get; set;}
Remarks
This property is True by default, meaning that table and field names are always escaped in generated SQL statements. This ensures that the names do not conflict with database- reserved words. Setting this property to False disables automatic quotation. Names that are not identifiers, for example, names containing spaces, are quoted regardless of this property value.

The quotation mark is determined by C1ExpressConnection.Connection.SqlInfo.NameQuote property value, for example, [field] in MS Access, "field" in SQL Server and Oracle.

See Also

Reference

C1ExpressConnection Class
C1ExpressConnection Members

 

 

Copyright © GrapeCity, Inc. All rights reserved.

Product Support Forum | Print this page