Using Linq to return a Comma separated string

Question

I have a class in my application

public class ProductInfo
{
  public int ProductId {get;set;}
  public int ProductType{get;set;}
}

I want to write a linq query which can return me a list of ProductIds in a comma separated format where ProductType is equal to certain number ?

I tried using string.join with my Linq statement but it didn't seem to work.

King King · Accepted Answer · 2013-09-24 20:30:19Z

288

var s = string.Join(",", products.Where(p => p.ProductType == someType)
                                 .Select(p => p.ProductId.ToString()));

edited Sep 24, 2013 at 20:30

answered Sep 24, 2013 at 20:26

King King

63.5k16 gold badges118 silver badges140 bronze badges

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

5 Comments

Sriram Sakthivel Over a year ago

Not even 1 minute completed :)

King King Over a year ago

@SriramSakthivel I know many people here always try to answer as quickly as possible :), I'm just a learner compared to them :)

Tikhon Over a year ago

How would you select multiple columns?

King King Over a year ago

@DougDexter not sure what you meant in this context. The OP's question is fairly specific about obtaining a string with some values separated by commas. So the result in Select should be a string or otherwise the ToString() on each item will be called to get a string. If you select multiple properties (as understood by you as columns), those properties still need to be combined somehow to make a string. So that's the unclear point. It depends more on how you want the data to be shaped.

Ryan Shripat Over a year ago

@jazzBox to select multiple columns, try the following: string.Join(",", products.Where(p => p.ProductType == someType) .Select(p => $"ID: {p.ProductId.ToString()} Name: {p.ProductName.ToString()}"));

Collectives™ on Stack Overflow

Using Linq to return a Comma separated string

1 Answer 1

5 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related