Messing Around with JOINs ResourceCal

JoinsAndResourceCalTests.cs

var resourceGroupRows = Db.ResourceGroup.Where(x => x.Company == Session.CompanyID
        && x.Inactive == false
        && 
    ).ToList();

var resourceCalRows = Db.ResourceCal.Where(x => x.Company == Session.CompanyID
        && x.SpecialDay >= DateTime.Today
    ).Join(Db.ResourceGroup,
            rc => new { rc.Company, rc.ResourceGrpID, Inactive = false },
            rg => new { rg.Company, rg.ResourceGrpID, rg.Inactive },
            (rc, rg) => rg
        ).ToList();
            
var resourceCalRows = Db.ResourceGroup
    .Where(rg => Db.ResourceCal.Any(rc => rc.Company == Session.CompanyID 
                                      && rc.SpecialDay >= DateTime.Today 
                                      && rc.ResourceGrpID == rg.ResourceGrpID 
                                      && rc.Company == rg.Company
                                      && rg.Inactive == false))
    .ToList();


var resourceCalRows = Db.ResourceCal
    .Where(rc => rc.Company == Session.CompanyID && rc.SpecialDay >= DateTime.Today)
    .Join(
        Db.ResourceGroup.Where(rg => rg.Inactive == false),
        rc => new { rc.Company, rc.ResourceGrpID },
        rg => new { rg.Company, rg.ResourceGrpID },
        (rc, rg) => rc
    )
    .ToList();

var resourceCalRows = Db.ResourceCal
    .Where(rc => rc.Company == Session.CompanyID && rc.SpecialDay >= DateTime.Today)
    .Join(
        Db.ResourceGroup,
        rc => new { rc.Company, rc.ResourceGrpID },
        rg => new { rg.Company, rg.ResourceGrpID },
        (rc, rg) => new { ResourceCal = rc, ResourceGroup = rg }
    )
    .Where(joined => joined.ResourceGroup.Inactive == false)
    .Select(joined => joined.ResourceCal)
    .ToList();



var resourceCalRows = Db.ResourceCal
    .Where(rc => rc.Company == Session.CompanyID 
                 && rc.SpecialDay >= DateTime.Today
                 && Db.ResourceGroup.Any(rg => rg.Company == rc.Company 
                                               && rg.ResourceGrpID == rc.ResourceGrpID  
                                               && rg.Inactive == false))
    .ToList();