如何使用count在四个表之间的Linq到EF连接中获取数据？

using (var context = new YourDbContext())
{
    var result = (from table1 in context.Table1
                  join table2 in context.Table2 on table1.Id equals table2.Table1Id
                  join table3 in context.Table3 on table2.Id equals table3.Table2Id
                  join table4 in context.Table4 on table3.Id equals table4.Table3Id
                  select new
                  {
                      // 选择需要的字段
                      Field1 = table1.Field1,
                      Field2 = table2.Field2,
                      Field3 = table3.Field3,
                      Field4 = table4.Field4
                  }).Count();
}

var result = (from table1 in context.Table1
              join table2 in context.Table2 on table1.Id equals table2.Table1Id
              join table3 in context.Table3 on table2.Id equals table3.Table2Id
              join table4 in context.Table4 on table3.Id equals table4.Table3Id
              where table1.Field1 == "SomeValue" // 添加筛选条件
              select new
              {
                  Field1 = table1.Field1,
                  Field2 = table2.Field2,
                  Field3 = table3.Field3,
                  Field4 = table4.Field4
              }).Count();