How to concatenate two column values inside List?

Question

I'm trying to concatenate two column values inside a list and respectively select all columns but all I can achieve is get a concatenated column inside list with no other existing columns data .As I loose other columns data inside list because I'm using select to concatenate .

Linq Query:

 data = data.Select(m => m.Name = m.Id + m.Place).ToList(); // m=>m kindoff with concatenation

I need data to be modified like column name Name will hold Id+Place and I get all columns data intact (Place,Address,etc) can be many more .

CodeHxr · Accepted Answer · 2018-05-02 14:07:24Z

3

Try something like this...

data = data.Select(m => new
{
    Name = $"{m.Id} {m.Place}", // Edit to add string interpolation
    Place = m.Place,
    Address = m.Address,
    etc = m.etc
});

While you don't "need" to include a name for m.Place, m.Address, etc. (Visual Studio will name them appropriately based off the of the property name), I find that it's easier to read if you keep the syntax consistent.

edited May 2, 2018 at 14:07

answered Apr 13, 2016 at 16:03

CodeHxr

9058 silver badges17 bronze badges

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

Comments

momar · Accepted Answer · 2016-04-13 16:11:10Z

1

Assuming you want to update specific fields you could use the foreach clause. This will update the values in place without needing to call ToList as well.

data.ForEach(m => m.Name = m.Id + m.Place);

answered Apr 13, 2016 at 16:11

momar

3641 silver badge3 bronze badges

1 Comment

super cool Over a year ago

cool that's the hack i'm so dumb not even gave a shot at foreach . cheers

Shyju · Accepted Answer · 2016-04-13 16:07:05Z

0

There are already two answers which should work for you. But they give you a list of anonymous objects.

The below will give a list of your custom class(instead of anonymous object) with the desired result.

var result = data.Select(m => new Category 
                                { Name = m.Name = m.Id + m.Place,
                                  Place = m.Place} ).ToList();

Update Category with your class name (the same class which data is a collection of or a different DTO/View model with those property names).

answered Apr 13, 2016 at 16:07

Shyju

220k106 gold badges421 silver badges499 bronze badges

1 Comment

super cool Over a year ago

nice one but this will (new)erase the existing data i'm afraid .

Salah Akbari · Accepted Answer · 2016-04-13 16:21:18Z

0

Use select new:

var data2 = from c in data
            select new
            {
                Name = c.Id + " " + c.Place,
                Place = c.Place,
                Address = c.Address
            };

Or:

var data3 = data.Select(c => new { c.Address, Name = string.Format("{0} {1}", c.Id, c.Place)});

edited Apr 13, 2016 at 16:21

answered Apr 13, 2016 at 16:02

Salah Akbari

40k10 gold badges85 silver badges115 bronze badges

Collectives™ on Stack Overflow

How to concatenate two column values inside List?

4 Answers 4

Comments

1 Comment

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

1 Comment

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related