>So if you use strongly typed datasets or objects how do you efficiently submit queries that you build at runtime base don filters and maybe users selecting only columns they want to see in a grid?
>
>By complex I mean the above. Dynamic queries that could be 1 table and 1 column from to x number of joins and x number of columns with filters the next time submitted.
I honestly haven't had a need for dynamic queries. I can effectively do all of my queries through Stored Procedures with a set data structure. If I needed to do the dynamic querying that you mention I would probably look at returning XML strings first