Search and Querying on one parent table and two children tables

Question

Search and Querying on one parent table and two children tables

I'm trying to have a screen where I have parameters for searching on multiple tables using one parent table and two related (children) tables to this parent table, while the two children tables are not related to each other.
 
 I use a query on one child table by following example from Beth Massi
 http://blogs.msdn.com/b/bethmassi/archive/2011/12/15/beginning-lightswitch-part-4-too-much-information-sorting-and-filtering-data-with-queries.aspx

This is easy to do because the Query Designer will allow us to create conditions that filter on related parent tables.

Is it possible to search and query  one these three tables in one single lightswitch screen?
Thanks,
Rachida

---

Rachida Dukes

Answer 1

It's not possible to do it at client side, you have to do it at server side.

So, you will need to pass the filter conditions to server side by Query parameters, then do the filter at server side in XXX_ProcessQuery method.

Answer 2

Thanks Ryan, I was hoping for an easier solution, I will try to follow your suggestion.

Rachida

---

Rachida Dukes

Answer 3

Rachda, I really hope there is a better solution too, but for now, the LINQ supported at client side is too weak, there is no group by , there is no aggregation, there is no sub-select...

Let's just hope it be improved in future version.

For filter scenario, you can look at the Filter Control Extension,  the filter control actually generate a filter string then pass it to server side, the server side do the actual filter. Although it not supported the child collection filtering, but it should be easy to make it work.( I've done something same, which support child-collection filtering ).

Hope it helps.