Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
SchemaSeparator Property

SqlCommandBuilder.SchemaSeparator Property

Gets or sets the character to be used for the separator between the schema identifier and any other identifiers.

Namespace:  System.Data.SqlClient
Assembly:  System.Data (in System.Data.dll)

[BrowsableAttribute(false)]
public override string SchemaSeparator { get; set; }

Property Value

Type: System.String
The character to be used as the schema separator.

Generally, database servers indicate the schema for a identifier by separating the schema name from the identifier with some character. For example, SQL Server uses a period, creating complete identifiers such as Person.CustomerName, where "Person" is the schema name and "CustomerName" is the identifier. Setting this property lets developers modify this behavior.

.NET Framework

Supported in: 4.6, 4.5, 4, 3.5, 3.0, 2.0

.NET Framework Client Profile

Supported in: 4, 3.5 SP1
Show:
© 2015 Microsoft