留言板

How to join multiple tables by multiple columns using DynamicQuery?

Kurt Xu,修改在10 年前。

How to join multiple tables by multiple columns using DynamicQuery?

Junior Member 帖子: 57 加入日期: 13-2-2 最近的帖子
I want to join multiple tables by multiple columns using DynamicQuery, but don't know how to do it. Say there are 2 tables, expandocolumn,expandovalue.

expandocolumn:
companyId
tableId

...

expandovalue:
valueId
companyId
tableId

...

I want to join expandocolumn to expandovalue by companyId and tableId using DynamicQuery API, is that possible to generate
expandocolumn.companyId=expandovalue.companyId and expandocolumn.tableId=expandovalue.tableId? Moreover, how to straight to get ExpandoValue and ExpandoColumn objects from the result?
Thanks
thumbnail
Rahul Pande,修改在10 年前。

RE: How to join multiple tables by multiple columns using DynamicQuery?

Expert 帖子: 310 加入日期: 10-7-7 最近的帖子
Hi Kurt,

Please have a look at this link.

HTH
Rahul
Kurt Xu,修改在10 年前。

RE: How to join multiple tables by multiple columns using DynamicQuery?

Junior Member 帖子: 57 加入日期: 13-2-2 最近的帖子
Rahul Pande:
Hi Kurt,

Please have a look at this link.

HTH
Rahul


Hello Rahul, I've researched the thread before, but it only talked about how to use just one column to join tables ,not two. And it uses subquery, not the shape of table1.a=table2.a .