CODEWITHSUNDEEP
c#linq
enigma20
enigma20

Reputation: 73

SELECT AS in Linq with WHERE clause

I am trying to populate a drop down list with a Linq query. However, I need to have FirstName and Surname as one field. Concatenating in the DDL.DataTextField returns a field not found error.

SQL would be something like this:

SELECT (FirstName + SPACE + Surname) AS FullName FROM Table WHERE ID=1

Current Linq:

public IList<mytable> GetNames(int p_ID)
{
    return db.mytable.Where(c => c.ID_fk == p_ID).ToList();
}

Upvotes: 7

Views: 60098

Answers (3)

Aghilas Yakoub
Aghilas Yakoub

Reputation: 28990

You can try with 

return db.mytable.Where(a => a.ID_fk==p_ID)
                  .Select(a => a.FirstName + "-" + a.Surname)
                  .ToList();

Upvotes: 1

stefano m
stefano m

Reputation: 4244

you could try this:

return db.mytable.Where(c => c.ID_fk == p_ID).Select(c=>c.FirstName + " " + c.Surname). ToList();

so you have a list of strings

Upvotes: 2

Daniel Hilgarth
Daniel Hilgarth

Reputation: 174397

You can use this, if you only need the full name:

public IList<string> GetNames(int p_ID)
{
    return db.mytable.Where(c => c.ID_fk == p_ID)
                     .Select(x => x.FirstName + " " + x.Surname)
                     .ToList();
}

Upvotes: 17

Related Questions