Linq 查询 .net MVC 的问题

Question

public ActionResult Performances(string id)
    {
        var query =
    from f in _db.Production
    join g in _db.Run on f.show equals g.Production.show
    join l in _db.Performance on g.startDate equals l.runStartDate
    where f.show == id
    select new ShowPerformance
    {
        Venuename = g.venue,
        Showname = f.show,
        RunStart = g.startDate,
        RunEnd = g.endDate,
        PerformanceDate = l.performanceDate,
        PerformanceTime = l.performanceTime
    };


    return View(query.ToList());


    }

该查询无法区分 ShowA run1 和 Show A run2 中的表演，它只是复制 ShowA run1 中的所有表演并显示运行2

Answer 1

我认为问题可能在于如何将性能加入到运行/生产中，

var query =
        from f in _db.Production
        join g in _db.Run on new {f.show, f.year} equals new {g.show, g.year}
        join l in _db.Performance on new {g.venue, g.startDate} equals new {l.venue, l.runStartDate}
        where f.show == id 
        select new ShowPerformance
        {
            Venuename = g.venue,
            Showname = f.show,
            RunStart = g.startDate,
            RunEnd = g.endDate,
            PerformanceDate = l.performanceDate,
            PerformanceTime = l.performanceTime
        };

而无需像 on g.runId equals l.runId 这样的东西，那么您将获得所有生产/运行的所有性能。