SqlCeCommandBuilder.QuoteSuffix Property

Note: This namespace, class, or member is supported only in version 1.1 of the .NET Framework.

Gets or sets the ending character or characters to use when specifying SQL Server database objects (for example, tables or columns) whose names contain characters, such as spaces or reserved tokens.

  [Visual Basic]
  Public Property QuoteSuffix As String
[C#]
public string QuoteSuffix {get; set;}
[C++]
public: __property String* get_QuoteSuffix();
public: __property void set_QuoteSuffix(String*);
[JScript]
public function get QuoteSuffix() : String;
public function set QuoteSuffix(String);

Property Value

The ending character or characters to use. The default is an empty string.

Exceptions

Exception Type Condition
InvalidOperationException This property cannot be changed after an INSERT, UPDATE, or DELETE command has been generated.

Remarks

Use the QuoteSuffix and QuotePrefix properties to specify delimiters, such as quotes, to encapsulate the object name.

Note   Although you cannot change the QuotePrefix or QuoteSuffix properties after an insert, update, or delete operation has been generated, you can change their settings after calling the update method of a data adapter.

Requirements

Platforms: .NET Compact Framework

.NET Framework Security:

See Also

SqlCeCommandBuilder Class | SqlCeCommandBuilder Members | System.Data.SqlServerCe Namespace

Syntax based on .NET Framework version 1.1.
Documentation version 1.1.1.

Send comments on this topic.

© Microsoft Corporation. All rights reserved.