Question

我愿比较一下我在哪一条款中收集的数字。我是否需要通过收集工作进行人工操作,以删除我想比较的一栏,或者是否有处理这种问题的通用方法?

我想这样说:

public IEnumerable<Cookie> GetCookiesForUsers(IEnumerable<User> Users)
{
    var cookies = from c in db.Cookies
              join uc in db.UserCookies on c.CookieID equals uc.CookieID
              join u in db.Users on uc.UserID equals u.UserID
              where u.UserID.Equals(Users.UserID)
              select c;
    return cookies.ToList();
}

I m用于利用Mlambda Linq到 syntax,但我决定审判Klok syntax,因为我当时正在使用。

这样做有什么好办法?

Answer 1

Try this:

public IEnumerable<Cookie> GetCookiesForUsers(IEnumerable<User> Users)
{
    var cookies = from c in db.Cookies
              join uc in db.UserCookies on c.CookieID equals uc.CookieID
              join u in db.Users on uc.UserID equals u.UserID
              where Users.Contains(u.UserID)
              select c;
    return cookies.ToList();
}

或许:

public IEnumerable<Cookie> GetCookiesForUsers(IEnumerable<User> Users)
{
    var cookies = from c in db.Cookies
              join uc in db.UserCookies on c.CookieID equals uc.CookieID
              join u in db.Users on uc.UserID equals u.UserID
              where Users.Select(x => x.UserID).Contains(u.UserID)
              select c;
    return cookies.ToList();
}

友情链接