如何在"where“中使用实体框架中的数组值

using System;
using System.Linq;

// 创建Person类
public class Person
{
    public int Id { get; set; }
    public string Name { get; set; }
    public string[] Interests { get; set; }
}

// 创建一个包含Person对象的集合
var people = new List<Person>
{
    new Person { Id = 1, Name = "John", Interests = new [] { "Reading", "Sports" } },
    new Person { Id = 2, Name = "Jane", Interests = new [] { "Travel", "Photography" } },
    new Person { Id = 3, Name = "Mike", Interests = new [] { "Sports", "Music" } }
};

// 假设我们要查找兴趣爱好包含"Sports"的人
var interestsToSearch = new [] { "Sports" };

// 使用实体框架进行查询
var matchedPeople = people.Where(p => interestsToSearch.All(i => p.Interests.Contains(i)));

// 输出匹配的人的姓名
foreach (var person in matchedPeople)
{
    Console.WriteLine(person.Name);
}