如何使用 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