entity-framework - EF3核心内存数据库OrderBy“序列不包含元素”异常

Question

这在连接到 SQL 时工作正常，但在使用内存数据库时抛出异常

Actors集合new List<Actor>在Movie构造函数中被初始化。

public class Actor
{
    public int ActorId { get; set; }
    public string Name { get; set; }
}

public class Movie
{
    public Movie()
    {
        Actors = new List<Actor>();
    }

    public int MovieId { get; set; }
    public string Name { get; set; }

    public virtual ICollection<Actor> Actors { get; set; }
}

var searchQuery = context.Movies.Where(m => m.Name == "Jaws");
searchQuery = searchQuery.OrderBy(m => m.Actors.Min(a => a.BirthDate ?? DateTime.MaxValue));

标签： entity-frameworklinq-to-sql

Answer 1

Actor = new List<Actor>试试这个，在构造函数中删除

public Movie()
{
}

在您的查询中.Include(m => m.Actor)

var searchQuery = context.Movies.Include(m => m.Actors).Where(m => m.Name == "Jaws");