Hi,
Please refer below code
C#
List<User> users = new List<User> {
new User{
UserId = 1,
UserName = "David"
},
new User{
UserId = 2,
UserName = "Kevin"
}
};
List<Membership> memberships = new List<Membership> {
new Membership{
UserId = 1,
IsApproved = true
},
new Membership{
UserId = 2,
IsApproved = false
}
};
//Join Using Lambda Expression
var result = users.Join(memberships, x => x.UserId, y => y.UserId, (user, member) => new { UserName = user.UserName, IsApproved = member.IsApproved });
// Join using Linq
var resultLinq = from user in users
join member in memberships
on user.UserId equals member.UserId
select new { UserName = user.UserName, IsApproved = member.IsApproved };
Classes
public class User
{
public int UserId { get; set; }
public string UserName { get; set; }
}
public class Membership
{
public int UserId { get; set; }
public bool IsApproved { get; set; }
}
I hope this will help you out.