Linq Syntax - select multiple columns

Question

This is my Linq syntax that I use for my entity model

IQueryable<string> objEmployee = null; objEmployee = from res in _db.EMPLOYEEs where (res.EMAIL == givenInfo || res.USER_NAME == givenInfo) select res.EMAIL; 

How to select multiple columns? Like I want to choose res.ID. And how can I get them? I think IQueryable is not working. And this is called Linq to SQL - right?

Answer 1

As the other answers pointed out, you need to use an anonymous type.

Regarding the syntax, I personally prefer the chaining method. The equivalent of a chain of methods would be: -

 var employee = _db.EMPLOYEEs .Where(x => x.EMAIL == givenInfo || x.USER_NAME == givenInfo) .Select(x => new { x.EMAIL, x.ID }); 

AFAIK, the declarative LINQ syntax is converted to a chain of method calls similar to this during compilation.

UPDATE

If you need the whole object, you just need to omit the Select() call, i.e.

 var employee = _db.EMPLOYEEs .Where(x => x.EMAIL == givenInfo || x.USER_NAME == givenInfo); 

Answer 2

You can use anonymous types, for example:

  var empData = from res in _db.EMPLOYEEs where res.EMAIL == givenInfo || res.USER_NAME == givenInfo select new { res.EMAIL, res.USER_NAME }; 

Answer 3

  var employee = (from res in _db.EMPLOYEEs where (res.EMAIL == givenInfo || res.USER_NAME == givenInfo) select new {res.EMAIL, res.USERNAME} ); 

OR you can use

  var employee = (from res in _db.EMPLOYEEs where (res.EMAIL == givenInfo || res.USER_NAME == givenInfo) select new {email=res.EMAIL, username=res.USERNAME} ); 

Explanation:

• Select employee from db as res.

• Filter employee information in accordance with the terms of the condition.

• Select the required fields from the employee object by creating an anonymous object using the new {}