LINQ LEFT JOIN where子句不起作用 [英] LINQ LEFT JOIN where clause not working

问题描述

我需要返回所有事件的列表以及用户可能为某个事件所拥有的任何rsvps.但是，无论我传递的用户名是什么，它都会返回每个rsvp.我的linq查询->

I need to return a list of all the events and any rsvps a user may have for an event. However, regardless of the username I pass, It returns every single rsvp. My linq Query ->

   return (from events in this._context.Context.Events
           join rsvps in (this._context.Context.RSVPs
                          .Where(o=> o.UserName == userName))
           on events equals rsvps.Event into re
           from rsvps in re.DefaultIfEmpty()
           select events);

关系是
Events.EventID = RSVPs.EventID

Relationship is
Events.EventID = RSVPs.EventID

推荐答案

from e in _context.Context.Events
join r in _context.Context.RSVPs.Where(o => o.UserName == userName)
    on e.EventID equals r.EventID into g
select new {
    Event = e,
    Rsvps = g
};

这篇关于LINQ LEFT JOIN where子句不起作用的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！