forum

home / developersection / forums / selecting multiple columns in linq

Ask Question

Selecting multiple columns in Linq

Sunil Singh 1412 13-Dec-2017 
objuser = from res in _db.users

              where (res.EMAIL == givenInfo || res.USER_NAME == givenInfo)

              select res.EMAIL;

How can I select multiple columns? 

linq linq  mvc 
Updated on 14-Dec-2017
Sunil Singh

Other

Follow
Can you answer this question?
Answer

1 Answers

Manish Kumar

Manish Kumar

14-Dec-2017

You can use like this

var employee = _db.EMPLOYEEs

    .Where(x => x.EMAIL == givenInfo || x.USER_NAME == givenInfo)

    .Select(x => new { x.EMAIL, x.ID });

Hope it helps you..

MindStick Training
MindStick Training

Liked By

We use cookies to ensure you have the best browsing experience on our website. By using our site, you acknowledge that you have read and understood our Cookie Policy & Privacy Policy