SqlFunctions.QuoteName Method

Definition

Namespace:

System.Data.Objects.SqlClient

Assembly:

System.Data.Entity.dll

Returns a Unicode string with the delimiters added to make the input string a valid Microsoft SQL Server delimited identifier.

Overloads

QuoteName(String)	Returns a Unicode string with the delimiters added to make the input string a valid Microsoft SQL Server delimited identifier.
QuoteName(String, String)	Returns a Unicode string with the delimiters added to make the input string a valid Microsoft SQL Server delimited identifier.

Remarks

You cannot call this function directly. This function can only appear within a LINQ to Entities query.

This function is translated to a corresponding function in the database. For information about the corresponding SQL Server function, see QUOTENAME (Transact-SQL).

QuoteName(String)

Returns a Unicode string with the delimiters added to make the input string a valid Microsoft SQL Server delimited identifier.

public:
 static System::String ^ QuoteName(System::String ^ stringArg);

[System.Data.Objects.DataClasses.EdmFunction("SqlServer", "QUOTENAME")]
public static string QuoteName (string stringArg);

[<System.Data.Objects.DataClasses.EdmFunction("SqlServer", "QUOTENAME")>]
static member QuoteName : string -> string

Public Shared Function QuoteName (stringArg As String) As String

Parameters

stringArg

String

The expression that quote characters will be added to.

Returns

String

The original string with brackets added.

Attributes

EdmFunctionAttribute

Remarks

You cannot call this function directly. This function can only appear within a LINQ to Entities query.

This function is translated to a corresponding function in the database. For information about the corresponding SQL Server function, see QUOTENAME (Transact-SQL).

QuoteName(String, String)

Returns a Unicode string with the delimiters added to make the input string a valid Microsoft SQL Server delimited identifier.

public:
 static System::String ^ QuoteName(System::String ^ stringArg, System::String ^ quoteCharacter);

[System.Data.Objects.DataClasses.EdmFunction("SqlServer", "QUOTENAME")]
public static string QuoteName (string stringArg, string quoteCharacter);

[<System.Data.Objects.DataClasses.EdmFunction("SqlServer", "QUOTENAME")>]
static member QuoteName : string * string -> string

Public Shared Function QuoteName (stringArg As String, quoteCharacter As String) As String

Parameters

stringArg

String

The expression that quote characters will be added to.

quoteCharacter

String

The one-character string to use as the delimiter. It can be a single quotation mark ( ' ), a left or right bracket ( [ ] ), or a double quotation mark ( " ). If quote_character is not specified, brackets are used.

Returns

String

The original string with the specified quote characters added.

Attributes

EdmFunctionAttribute

Remarks

You cannot call this function directly. This function can only appear within a LINQ to Entities query.

This function is translated to a corresponding function in the database. For information about the corresponding SQL Server function, see QUOTENAME (Transact-SQL).