Click here to Skip to main content
15,900,378 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I need to design a query designer in silverlight
It's functionality is same as query designer which comes
by default with visual studio.
Also i need to provide facility for designing sub query.
Please give me some guidlines to complete this task
Posted

1 solution

That sounds like a pretty tricky requirement. It comprises many problems, so let's break it up a bit...

1. You need to know what tables and columns are available in the database / on the server
2. You need to pass this information to the SL app via a web service
3. You need a way of creating a query on the client side (I presume visually) out of the available information
4. You need to pass the query to the web service and retrieve the result

For the first and third steps you could refer to this article which shows how to interrogate the schema and build a query with the results.

For the second and last steps you could refer to some of the techniques in this article, which describes using Dynamic LINQ for dynamic queries and how to get dynamic results through a web service and use them on the client side.

Hopefully that will give you food for thought. If you want a more specific answer you'd have to narrow the question right down, as you're asking a very broad question.
 
Share this answer
 
v2

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900