linq三个表join查询的c#语句

假设要连接的三个表为A、B、C，它们之间的关系是A与B通过字段A.B_id关联，B与C通过字段B.C_id关联，可以使用以下的C#语句进行连接查询： ```csharp var query = from a in context.A join b in context.B on a.B_id equals b.Id join c in context.C on b.C_id equals c.Id select new { APro[per](https://geek.csdn.net/educolumn/2c6ed1be7edac16b3c9a0c3228eaff0c?spm=1055.2569.3001.10083)ty1 = a.Property1, AProperty2 = a.Property2, BProperty1 = b.Property1, BProperty2 = b.Property2, CProperty1 = c.Property1, CProperty2 = c.Property2 其中，context是数据库上下文[对象](https://geek.csdn.net/educolumn/04c51611e4b730957464192e0307b82c?spm=1055.2569.3001.10083)，A、B、C是上下文中对应的[实体](https://geek.csdn.net/educolumn/032fadf792a9d75ffa33410b908fe2c4?spm=1055.2569.3001.10083)集，Id、B_id、C_id是各个[实体](https://geek.csdn.net/educolumn/032fadf792a9d75ffa33410b908fe2c4?spm=1055.2569.3001.10083)对应的关联字段，在select子句中可以[选择](https://geek.csdn.net/educolumn/1702526fead21a13fe2bdd53c9e98b89?spm=1055.2569.3001.10083)需要的属性进行投影。