forum

Home / DeveloperSection / Forums / Selecting multiple columns in Linq

Selecting multiple columns in Linq

Sunil Singh 1186 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 mvc

Updated on 14-Dec-2017

Can you answer this question?

Answer

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..