I have four different tables with strong relation like

Table 1 --> A,B Table 2 --> B,C,M Table 3 --> C,D Table 4 --> D,N

Now I need to write a method to get all the results in Table 4 which is belongs to A in Table 1.

thanks in advance.

bibekd wrote:

Table 1 --> A,B Table 2 --> B,C,M Table 3 --> C,D Table 4 --> D,N

I'm not sure what the letters mean

bibekd wrote:

Now I need to write a method to get all the results in Table 4 which is belongs to A in Table 1.

Anyway, you should be able to do that using IPredicateExpression and IRelationCollection. Are you using Adapter or SelfServicing?

Take a look at this example.