This is my Linq Syntax which I am using to 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 can I select multiple columns? Like I want to select res.ID aswell. And how can I receive those? IQueryable will not work I think.
And this is called Linq to SQL – right ?
Best Answer
As the other answers have indicated, you need to use an anonymous type.
As far as syntax is concerned, I personally far prefer method chaining. The method chaining equivalent would be:-
AFAIK, the declarative LINQ syntax is converted to a method call chain similar to this when it is compiled.
UPDATE
If you want the entire object, then you just have to omit the call to
Select()
, i.e.