DbCommandBuilder.QuoteSuffix 属性


获取或设置一个或多个结束字符,供指定其名称中包含空格或保留标记等字符的数据库对象(例如,表或列)时使用。Gets or sets the ending character or characters to use when specifying database objects (for example, tables or columns) whose names contain characters such as spaces or reserved tokens.

 virtual property System::String ^ QuoteSuffix { System::String ^ get(); void set(System::String ^ value); };
public virtual string QuoteSuffix { get; set; }
member this.QuoteSuffix : string with get, set
Public Overridable Property QuoteSuffix As String


要使用的结束字符。The ending character or characters to use. 默认值为一个空字符串。The default is an empty string.


某些数据源可能包含可以包含字符(如空格、逗号和分号)的对象。Some data sources may have objects that can contain characters such as spaces, commas, and semicolons. 若要容纳此功能,请使用 "QuotePrefix" 和 "QuoteSuffix" 属性来指定分隔符(如左括号和右括号)以封装对象名称。To accommodate this capability, use the QuotePrefix and QuoteSuffix properties to specify delimiters such as a left bracket and a right bracket to encapsulate the object name.


尽管在生成 insert、update 或 delete 命令后无法更改 QuotePrefixQuoteSuffix 属性,但你可以在调用 DbDataAdapterUpdate 方法之后更改其设置。Although you cannot change the QuotePrefix or QuoteSuffix properties after an insert, update, or delete command has been generated, you can change their settings after calling the Update method of a DbDataAdapter.