How to Translate this LINQ Query to use Lambda Expressions Instead?

Question

i want this bellow syntax write by useing the lamda expression

  from p in this.Context.tblUserInfos
                where p.Status == 1
                select new {p.UserID,p.UserName,p.tblUserType.UserType };

suppose i write

this.Context.tblUserInfos.Where(p => p.Status == 1);

How to write the above syntax by using the => operator.

Answer 1

this.Context.tblUserInfos.Where(p => p.Status == 1)
            .Select(p => new { p.UserID, p.UserName, p.tblUserType.UserType });

Answer 2

Use the .Select IEnumerable extension method to project the result set into an anonymous type.

Like this:

var someAnonymousType = this.Context.tblUserInfos
                             .Where(p => p.Status == 1)
                             .Select(p => new {p.UserID,p.UserName,p.tblUserType.UserType };);

Answer 3

Well you already have the where portion of it in there so I am assuming you only need the select:

this.Context.tblUserInfos
            .Where(p => p.Status == 1)
            .Select(p => new { p.UserID, p.UserName, p.tblUserType.UserType });

Answer 4

LINQPad can convert queries between LINQ and lambda syntax