如何集成查询存储库中多个实体并将数据发送到View的Linq-to-Entity查询

我正在学习MVC、存储库模式和EF，我需要一些关于如何最好地将包含查询多个实体的查询的方法集成到存储库中的建议。

目前，我已经创建了一个存储库类，它实现了一个接口，并使用DbContext的实例使用实体框架从数据库中检索数据，但只针对一个实体。

已编辑。。。我的存储库中有GetJourneys（）方法，但我不确定如何从Controller中的查询中获取Journey详细信息。我可以获取用户详细信息。

public IEnumerable<User> GetJourneys()
    {
        var todayDate = DateTime.Now;
        //Woking with many to many Relationship 
        //(join tables) in Asp.net MVC/Entity Framework
        var viewModel = from j in dbContext.Users
                        from u in dbContext.Journeys
                        where u.DepartDate >= todayDate.Date
                        orderby u.DepartDate ascending
                        select j;
        return viewModel.ToList();
    }

下面是我的用户实体

public class User
{
    [Key, Required]
    public int UserID { get; set; }
    [MaxLength(30), Required]
    public string FirstName { get; set; }
    [MaxLength(30), Required]
    public string LastName { get; set; }
    [Required]
    public string ProfileImg { get; set; }
    [MaxLength(30), Required]
    public string FbLink { get; set; }
    public ICollection<Journey> Journeys { get; set; }
}

下面是我的控制器

public ViewResult Search()
    {
        var userJourneyList = from user in repository.GetJourneys() select user;
        var searchView = new List<SearchViewModel>();
        try
        {
            if (userJourneyList.Any())
            {
                foreach (var user in userJourneyList)
                {
                    searchView.Add(new SearchViewModel()
                    {
                        //JourneyDestination = user.Journeys.FromDestination,
                        //JourneyDate = user.Journeys.DepartDate,
                        UserName = user.FirstName,
                        ProfileImage = user.ProfileImg,
                        //SeatsAvailable = user.Journeys.SeatsAvailable,
                        //UserType = user.Journeys.UserType
                    });
                }
                returnAmount = 1;
                ViewBag.Amount = returnAmount;
            }
            else
            {
                returnAmount = 0;
                ViewBag.Amount = returnAmount;
            }
            var todayDate = DateTime.Now;
        }
        catch (NullReferenceException ex)
        {
            MessageBox.Show(ex.Message);
        }
        return View(searchView.ToList());
    }

更新现在在我的存储库中

public IList<User> GetAllUsersWithJourneys()
    {
        using (var db = new EfDbContext())
        {
            var users = from userJourney in db.Users.Include(i => i.Journeys)
                        select userJourney;
            return users.ToList();
        }
    } 

然而，我仍然不知道如何获得旅程的详细信息。"我的用户"answers"旅程"实体在多对多关系方面是正确的。下面是具有新存储库方法的控制器。

        var userJourney = repository.GetAllUsersWithJourneys();
        var searchView = new List<SearchViewModel>();
        try
        {
            if (userJourneyList.Any())
            {
                foreach (var user in userJourney)
                {
                    searchView.Add(new SearchViewModel()
                        {
                            UserName = user.FirstName,
                            JourneyDestination = user.Journeys.ToDestination //ERROR
                        });
                }
            }
            else
            {
                //user will be notified that no results were found and that they are given the option to create the journey that they seek
                returnAmount = 0;
                ViewBag.Amount = returnAmount;
            }
        }
        catch (NullReferenceException ex)
        {
            MessageBox.Show(ex.Message);
        }
        return View(searchView.ToList());

我的ViewModel看起来像这个

public class SearchViewModel
{
    public string ProfileImage { get; set; } //User
    public string JourneyDestination { get; set; } //Journey
    public DateTime JourneyDate { get; set; } //Journey
    public string UserName { get; set; } //User
    public int SeatsAvailable { get; set; } //Journey
    public bool UserType { get; set; } //Journey
}