SqlCommandBuilder.SchemaSeparator Property

Definition

Namespace:

System.Data.SqlClient

Assembly:

System.Data.SqlClient.dll

Package:

System.Data.SqlClient v4.9.0

Source:

System.Data.SqlClient.notsupported.cs

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

public:
 virtual property System::String ^ SchemaSeparator { System::String ^ get(); void set(System::String ^ value); };

public override string SchemaSeparator { get; set; }

member this.SchemaSeparator : string with get, set

Public Overrides Property SchemaSeparator As String

Property Value

String

The character to be used as the schema separator.

Remarks

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.

See also

• Connecting and Retrieving Data in ADO.NET
• Using the .NET Framework Data Provider for SQL Server
• ADO.NET Overview