Concatenate two column values in LINQ Lambda Expression

Question

I have a table where there are two columns. First_Name and Last_name. I am populating a gridview using LINQ.

protected void Page_Load(object sender, EventArgs e)
    {
        myLinQtoSQLClassDataContext objDataContext = new myLinQtoSQLClassDataContext();

        var allUserList = from CurrentUser in objDataContext.Users.Where(c => c.Is_Deleted != false)                              
                          select new
                          {
                              CurrentUser.First_Name, 
                              CurrentUser.Last_Name,
                              CurrentUser.Email_ID,
                              CurrentUser.GUID
                          };

        GridView1.DataSource = allUserList;
        GridView1.DataBind();                              
    }

I can retrieve the values using LINQ, but I want to concatenate the first name and last name with a space in between.

The equivalent SQL query what I am trying to achieve would be like this:

Select First_name + ' ' + Last Name as Username, Email_ID, GUID
From tbl_Users where Is_Deleted != false

How can I achieve this through the lambda expression?

In SQL you should normally use ' ' to mean a string containing a space., not " ". — Mark Byers
– Mark Byers, Commented Apr 19, 2012 at 9:26

Mark Byers · Accepted Answer · 2012-04-19 09:24:45Z

25

You can use string concatenation:

select new
{
    Username = CurrentUser.First_Name + " " + CurrentUser.Last_Name,
    CurrentUser.Email_ID,
    CurrentUser.GUID
};

answered Apr 19, 2012 at 9:24

Mark Byers

844k202 gold badges1.6k silver badges1.5k bronze badges

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

Comments

TylerH · Accepted Answer · 2023-10-03 20:15:20Z

4

Try

select new
{
    FullName = CurrentUser.First_Name + " " + CurrentUser.Last_Name,
    CurrentUser.Email_ID,
    CurrentUser.GUID
};

edited Oct 3, 2023 at 20:15

TylerH

21.3k84 gold badges84 silver badges121 bronze badges

answered Apr 19, 2012 at 9:24

Mithrandir

25.5k6 gold badges53 silver badges67 bronze badges

Comments

Habib · Accepted Answer · 2012-04-19 09:26:39Z

2

var allUserList = from CurrentUser in objDataContext.Users.Where(c => c.Is_Deleted != false)                              
                  select new
                  {
                      Name = CurrentUser.First_Name + " " + CurrentUser.Last_Name, 
                      CurrentUser.Email_ID,
                      CurrentUser.GUID
                  };

answered Apr 19, 2012 at 9:26

Habib

224k30 gold badges420 silver badges446 bronze badges

Comments

Grant Thomas · Accepted Answer · 2012-04-19 09:25:27Z

1

You should give your anonymous type 'keys' (read-only properties):

select new
{
  Name = CurrentUser.First_Name + " " + CurrentUser.Last_Name,
};

And then just concatenate the string on assigning the user name.

answered Apr 19, 2012 at 9:25

Grant Thomas

45.1k10 gold badges88 silver badges129 bronze badges

Comments

Pranay Rana · Accepted Answer · 2012-04-20 06:12:33Z

1

have a look at this CLR Method to Canonical Function Mapping
.Net provides many methods that can be directly mapped to the queries ull have to use one of them to add two strings
so one that u can use is

select new 
{ 
    Username = Concat(first_Name,Last_Name), 
    CurrentUser.Email_ID, 
    CurrentUser.GUID 
};

edited Apr 20, 2012 at 6:12

Pranay Rana

177k37 gold badges244 silver badges267 bronze badges

answered Apr 19, 2012 at 9:27

Parv Sharma

12.7k5 gold badges52 silver badges83 bronze badges

Comments

Bruno · Accepted Answer · 2014-07-30 20:19:12Z

1

Here's another variation that works and has not been listed:

var allUserList =  objDataContext.Users.Where(c => c.Is_Deleted != false).
     Select(s => new{First_Name + " " + Last_Name, Email_ID, GUID});

answered Jul 30, 2014 at 20:19

Bruno

5631 gold badge6 silver badges27 bronze badges

1 Comment

Charly H Over a year ago

var allUserList =  objDataContext.Users.Where(c => c.Is_Deleted != false).Select(s => new{FullName = First_Name + " " + Last_Name, Email_ID, GUID});

worked for me. I needed to add FullName as a Field

tselvakumars · Accepted Answer · 2019-06-30 18:31:37Z

0

select new
{
    Username = string.Format("{0} {1}", CurrentUser.First_Name, CurrentUser.Last_Name),
    CurrentUser.Email_ID,
    CurrentUser.GUID
};

answered Jun 30, 2019 at 18:31

tselvakumars

11 silver badge

Collectives™ on Stack Overflow

Concatenate two column values in LINQ Lambda Expression

7 Answers 7

Comments

Comments

Comments

Comments

Comments

1 Comment

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

7 Answers 7

Comments

Comments

Comments

Comments

Comments

1 Comment

Comments

Linked

Related