How to get all Solutions within a department

          var Query = (
            from d in Context.Departments
            from s in Context.SolutionDepartments
            from c in Context.DepartmentContactBridges
            where d.DepartmentID == s.DepartmentID && d.DepartmentID == c.DepartmentID && d.Active == true
            select new
            {
              d.DepartmentID, d.DepartmentName, s.SolutionID
            }
          );