Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

+ (String Concatenation)

Concatenates two strings.

expression+expression
expression
Any valid expression of the EDM.String data types. Both expressions must be of the same data type, or one expression must be able to be implicitly converted to the data type of the other expression.

The data type that results from the implicit type promotion of the two arguments. For more information about implicit type promotion, see Type System.

The following Entity SQL query uses the + operator to concatenates two strings. The query is based on the AdventureWorks Sales Model. To compile and run this query, follow these steps:

  1. Follow the procedure in How to: Execute a Query that Returns PrimitiveType Results.

  2. Pass the following query as an argument to the ExecutePrimitiveTypeQuery method:


SELECT VALUE 'Name=[' + e.Name + ']' FROM
AdventureWorksEntities.Products AS e
    




Build Date:

2012-10-01
Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft. All rights reserved.