FromQuery无限连表

[ROMYIM]

看了一下官网文档，说FromQuery可以无限连表。但是例子和api说明FromQuery只能传单个表的，而且也不能一致链式调用FromQuery

期望通过freeSql api构建如下查询。可以无限连接多个子查询

SELECT count(1) as1
FROM [case_fee_list] CaseFeeList With(NoLock)
 INNER JOIN 
    (select case_id, proc_id from [case_proc_info] With(NoLock) where is_enabled = 1)
 CaseFeeList__CaseProcInfo 
     ON CaseFeeList__CaseProcInfo.[proc_id] = CaseFeeList.[proc_id] 
 INNER JOIN 
    (select case_id from [case_info]  With(NoLock) where customer_id  = N'6B3A0677-789C-4F21-9994-591549D4E843') CaseFeeList__CaseProcInfo__CaseInfo
     ON CaseFeeList__CaseProcInfo__CaseInfo.[case_id] = CaseFeeList__CaseProcInfo.[case_id] 
.....（继续连其他子查询表）
WHERE 
    (CaseFeeList.[receive_status] = N'0') 

[2881099]

明白你的意思，可以这样写：

_freesQuery
    .FromQuery(_procInfoQuery)
    .InnerJoin((a,b) => ....)
    .WithTempQuery((a,b) => new { item1 = a, item2 = b })
    .FromQuery(_caseInfoQuery)
    .InnerJoin((a,b) => a.item1.id == b.id)
    ...

产生的 Sql ：

SELECT ...
FROM
(
    SELECT ...
    FROM [case_fee_list] CaseFeeList With(NoLock)
    INNER JOIN (select case_id, proc_id from [case_proc_info] With(NoLock) where is_enabled = 1) CaseFeeList__CaseProcInfo ON 
    CaseFeeList__CaseProcInfo.[proc_id] = CaseFeeList.[proc_id] 
) a
 INNER JOIN 
    (select case_id from [case_info]  With(NoLock) where customer_id  = N'6B3A0677-789C-4F21-9994-591549D4E843') CaseFeeList__CaseProcInfo__CaseInfo
     ON CaseFeeList__CaseProcInfo__CaseInfo.[case_id] = CaseFeeList__CaseProcInfo.[case_id] 
WHERE 
    (CaseFeeList.[receive_status] = N'0') 

[Jess-Qiu]

😃正好碰到跟你一样的问题，明天试试这个写法