官网上好像没查到资料
SELECT * FROM "T1" o
join "T2" iu on o."NodePath" like iu."NodePath" || '%'
where iu."Id" = '123456'
from o in context.InspectUnit
join iu in context.InspectUnit on o.NodePath.StartsWith(iu.NodePath)
where iu.Id == "123456"
orderby o.Name
select o
这样写linq会报错表示on条件必须使用equals连接
SELECT * FROM "T1" o
join "T2" iu on o."NodePath" like iu."NodePath" || '%'
where iu."Id" = '123456'
from o in context.InspectUnit
join iu in context.InspectUnit on o.NodePath.StartsWith(iu.NodePath)
where iu.Id == "123456"
orderby o.Name
select o
这样写linq会报错表示on条件必须使用equals连接
