使用Linq to Entities返回与可能字符串列表匹配的记录

using System;
using System.Linq;

// 假设有一个名为"Customers"的数据库表，包含"Name"字段

public class Customer
{
    public int Id { get; set; }
    public string Name { get; set; }
}

public class Program
{
    public static void Main()
    {
        // 假设存在一个字符串列表，用于匹配记录
        var searchList = new List<string> { "John", "Alice", "Bob" };

        using (var context = new YourDbContext())
        {
            var matchedCustomers = context.Customers
                .Where(c => searchList.Contains(c.Name))
                .ToList();

            foreach (var customer in matchedCustomers)
            {
                Console.WriteLine($"Id: {customer.Id}, Name: {customer.Name}");
            }
        }
    }
}