How to concatenate two fields in LINQ?

Question

I am trying to combine two fields for e.g. FullName = FirstName + LastName

How can I accomplish in the following code?

IEnumerable<Item> Items = from item in _entities.Items
where Item.ID == Id 
orderby contractItem.Item.ItemName
select new Item
{
   Id = item.ID,
   ...
   CreatedBy = (from employee in _entities.Employees
                where employee.UserID == item.CreatedBy
                select new {
                             FirstLast = employee.FName + " " + employee.LName}).FirstOrDefault(), // <---- gives me an error
   ...
};

what error does it give you?

gingerbreadboy
– gingerbreadboy

2014-02-12 17:08:14 +00:00
Commented Feb 12, 2014 at 17:08 — gingerbreadboy
– gingerbreadboy, Commented Feb 12, 2014 at 17:08

Habib · Accepted Answer · 2014-02-12 17:08:18Z

4

Looks like CreatedBy in Item is a type of string property and since in your query you are using select new it is creating an anonymous type. You can modify it like:

    (from employee in _entities.Employees
    where employee.UserID == contractItem.CreatedBy
    select employee.FName + " " + employee.LName).FirstOrDefault()

So your complete query would be like:

IEnumerable<Item> Items = from item in _entities.Items
where Item.ID == Id 
orderby contractItem.Item.ItemName
select new Item
{
   Id = item.ID,
   ...
   CreatedBy = (from employee in _entities.Employees
                where employee.UserID == item.CreatedBy
                select employee.FName + " " + employee.LName).FirstOrDefault(), 
};

answered Feb 12, 2014 at 17:08

Habib

224k30 gold badges420 silver badges446 bronze badges

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

Collectives™ on Stack Overflow

How to concatenate two fields in LINQ?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related