I am trying to use(inner join) query in MVC page. How can this be done using the Adapter.

SELECT A.AID,B.BID,C.ntext FROM TABLEA A INNER JOIN TABLEB B ON A.AID = B.BID INNER JOIN TABLEC C ON B.BID = C.CID INNER JOIN TABLED D ON A.TYPEID = D.TypeID where c.user_name = 'test'

I saw some examples online but I am not sure how to add relations between 3 or more tables. Please help.

Hi there,

To add more relations just add them:

bucket.Relations.Add(TableAEntity.Relations.TableBEntityUsing...);
bucket.Relations.Add(TableBEntity.Relations.TableCEntityUsing...);
...

I assume that you already have mapped those relations into your LLBLGen project. Is that what you are looking for?

Next time, please pick the right forum. Thanks.

Thanks for your hint. I added the relations. But I am trying to get the values from all these tables. Here is my code. How can I get the column values from TableA, TableB and TableC? This code only works for TableA. I couldn't get the column values from TableB and TableC.

EntityCollection TableACollection = new EntityCollection(new TableAEntityFactory()); RelationPredicateBucket bucket = new RelationPredicateBucket(); bucket.Relations.Add(TableAEntity.Relations.TableBEntityUsingAid); bucket.Relations.Add(TableAEntity.Relations.TableCEntityUsingCId);

       using (DataAccessAdapter adapter = new DataAccessAdapter())
        {
            adapter.FetchEntityCollection(TableACollection, bucket);
            foreach(TableAEntity tableAItem in TableACollection)
            {
                model.StartDate =tableAItem.StartDt.ToString();
             }
        }

But I am trying to get the values from all these tables

If you want to pick values from more than one table (joined), in a flat way, then you should be using a DynamicList, not an entityCollection.