有下面的语句,
select distiinct name,pass, userid from users where name like '%z' order by userid desc;
select distiinct name,pass, userid from users where name like '%z' order by userid desc;
怎么用LINQ来实现这种查询的效果?
- public class UserComparer : IEqualityComparer<User>
- {
- public bool Equals(User u1, User u2)
- {
- return u1.Name==u2.Name;
- }
- public int GetHashCode(User u)
- {
- return u.ToString().GetHashCode();
- }
- }
- var query=db.Users.Where(u=>u.Name.EndWith("z"))
- .OrderByDescending(u=>u.userid)
- .Disctinct(new UserComparer());