How to write this linq query using Lambda expression

Question

public List<Employee> GetList()
 {
     return (from c in DALContext.MST
             select new Employee(ID=c.CD, Name=c.NAME)).ToList();
 }

Jon · Accepted Answer · 2011-03-20 06:22:44Z

5

Try this:

public List<Employee> GetList()
{
    return DALContext.MST.Select(c => new Employee { ID = c.CD, Name = c.NAME }).ToList();
}

answered Mar 20, 2011 at 4:38

Jon

16.8k8 gold badges54 silver badges62 bronze badges

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

3 Comments

new Employee(ID = c.CD, Name = c.NAME) should be new Employee{ID = c.CD, Name = c.NAME}

@Metro of course you're right - I was focussing on the extension method bit and totally missed the syntax error. Thanks :)

if you were using named parameters, it would be: new Employee(ID: c.CD, Name: c.NAME)