Silverlight中的查询设计器 [英] Query designer in silverlight

问题描述

我需要在silverlight中设计查询设计器
它的功能与附带的查询设计器相同
Visual Studio默认情况下.
我还需要提供设计子查询的工具.
请给我一些指导以完成此任务.

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

推荐答案

这听起来很棘手.它包含许多问题，所以让我们对其进行分解...

1.您需要知道数据库/服务器上可用的表和列
2.您需要通过Web服务将此信息传递给SL应用
3.您需要一种从可用信息中在客户端(我以视觉方式假定)创建查询的方法
4.您需要将查询传递到Web服务并检索结果

对于第一步和第三步，您可以参考本文，其中显示了如何询问模式并使用结果构建查询.

对于第二步也是最后一步，您可以参考

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.

这篇关于Silverlight中的查询设计器的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！