在来自不同表的连接字段中使用'and‘运算符的Linq搜索文本

// 定义两个表的数据源
var table1 = new List<Person>
{
    new Person { Id = 1, Name = "John", Age = 25 },
    new Person { Id = 2, Name = "Alice", Age = 30 },
    new Person { Id = 3, Name = "Bob", Age = 35 }
};

var table2 = new List<Address>
{
    new Address { Id = 1, City = "New York", Country = "USA" },
    new Address { Id = 2, City = "London", Country = "UK" },
    new Address { Id = 3, City = "Paris", Country = "France" }
};

// 使用Join操作符连接两个表，并使用Where操作符进行文本搜索
var query = from person in table1
            join address in table2 on person.Id equals address.Id
            where person.Name.Contains("o") && address.City.Contains("o")
            select new { person.Name, address.City };

// 执行查询并输出结果
foreach (var result in query)
{
    Console.WriteLine($"Name: {result.Name}, City: {result.City}");
}