将具有同一表的多个连接(具有多个条件)的SQL转换为LINQ

SELECT *
FROM Table1 t1
JOIN Table2 t2 ON t1.Column1 = t2.Column1
JOIN Table3 t3 ON t1.Column2 = t3.Column2
WHERE t1.Column3 = 'value'

var dbContext = new YourDbContext();

var query = from t1 in dbContext.Table1
            join t2 in dbContext.Table2 on t1.Column1 equals t2.Column1
            join t3 in dbContext.Table3 on t1.Column2 equals t3.Column2
            where t1.Column3 == "value"
            select new
            {
                // 选择需要的字段
                // 可以使用匿名类型或自定义类型
                // 例如：Field1 = t1.Column1, Field2 = t2.Column2, ...
            };

var result = query.ToList();