如何使用 LINQ 从两个表编写条件查询

Question

两个数据库中有两个表 促销：代码、来源、经纪人 经纪人编号：ID、姓名、经纪人编号 我要查询的是所有满足 Promotion.broker=BrokerNo.BrokerNo 和 Promotion.source="asdf" 条件的 BrokerNo.Name 记录 如何使用LINQ编写查询语句？

Answer 1

from promotion in Promotion
from brokerNo in BrokerNo
where promotion.source == "asdf" && promotion.broker == brokerNo.BrokerNo
select brokerNo.Name