asp.net mvc - LINQ Query to select specific columns

Question

the following code returns all information of table if credentials matches. But I want to write another query inside else condition block where it will return me only specific columns of admins table, for example Email, Name, and Role. How can I do that?

Admin adminLoggedin  = db.Admins.SingleOrDefault(x => x.Email==model.Email && x.Password == model.Password);
if (adminLoggedin == null)
{
    return BadRequest();
}
else
{
    // ***Query2  select Email , Name, RoleId from Admins Where Email = adminLoggedin.Email 
    // how to write this query with Entity framework and ado.net model

    FormsAuthentication.SetAuthCookie(model.Email, model.RememberMe);
                        return Ok(adminLoggedin);
}

Mohsin Mehmood · Accepted Answer · 2018-06-16 17:17:28Z

1

Using anonymous type and query syntanx, you can write something like this:

var query = from admin in db.Admins
where admin.Email == adminLoggedIn.Email
select new { Email=admin.Email, Name=admin.Name, RoleId = admin.RoleId };

If you need to return this query results from this function, create a simple class with properties Name, Email etc and then use it with select clause in above query e.g. select new CustomClass {Email, admin.Email,}

answered Jun 16, 2018 at 17:17

Mohsin Mehmood

4,2662 gold badges15 silver badges18 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

asp.net mvc - LINQ Query to select specific columns

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related