Products

Data Converter Cleaner TUC - Unit Converter Import Export Survey Manager Tweet Controller

Developer

Article Blog Forum Interview Beginner News Startup Quiz

Users

Career

Apply Job Internship

Pricing

Login Sign Up Get a Quote

Selecting multiple columns in Linq

Sunil Singh 1489 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?

Sunil Singh

Other

1 Answers

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

advertising