Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Best Design For This
Message
From
30/03/2009 12:35:54
Mike Cole
Yellow Lab Technologies
Stanley, Iowa, United States
 
General information
Forum:
ASP.NET
Category:
Coding, syntax and commands
Miscellaneous
Thread ID:
01390847
Message ID:
01392143
Views:
62
>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
Very fitting: http://xkcd.com/386/
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform