To concatenate values of a particular column in multiple rows using linq [duplicate]

Question

I have a table in sql server with the following structure.

tblFruit:

╔════╦══════════════╦══════╗
║ Id ║  Fruit       ║ Color║
╠════╬══════════════╬══════╣
║  1 ║ Peacock      ║ Red  ║
║  2 ║ Hawk         ║ Green║
║  3 ║ Lion         ║ Red  ║
║  4 ║ Lizard       ║ Red  ║
╚════╩══════════════╩══════╝

This is my query in LINQ :

db.Fruits.Where(r => r.Color == "Red")
         .Select(r => r.Fruit)
         .ToList()

I will get 3 rows of result from the table.

However I need the result to be Peacock,Lion,Lizard. Is there a way of getting this from LINQ or should I use a foreach loop and concatenate manually?

Blue · Accepted Answer · 2018-08-02 20:34:08Z

3

You can use String.join():

var fruits = db.Fruits.Where(r => r.Color == "Red")
                      .Select(r => r.Fruit)
                      .AsEnumerable();

Console.WriteLine(String.join(",", fruits));

edited Aug 2, 2018 at 20:34

answered Aug 2, 2018 at 20:10

Blue

23k7 gold badges69 silver badges102 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

Rui Jarimba Over a year ago

Does String.Join work with Linq to Entities?

Blue Over a year ago

@maccettura Sorry, javascript is starting to slowly consume my soul

Gert Arnold Over a year ago

No. In EF6 this will be translated into SQL and string.Join is not supported. You have to use fruits.AsEnumerable().

Rui Jarimba Over a year ago

@GertArnold exactly what I was trying to say, thanks for the more decent explanation :)

Blue Over a year ago

@GertArnold Yes, you are correct. You will need to involve .ToList(), .ToArray(), or .AsEnumerable(); before working with the data, to avoid the magic behind the scenes of the IQueryable interface.

Collectives™ on Stack Overflow

To concatenate values of a particular column in multiple rows using linq [duplicate]

1 Answer 1

5 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Linked

Related