现成的控件为非技术用户生成SQL查询 [英] Off the shelf control to generate SQL queries for non technical users
问题描述
任何人都可以推荐现成的（免费或付费）控件（C＃WinForms），它将为用户提供拖放功能，以便从任何SQL数据库查询数据。
此目的用于一般分段。例如，用户可能希望获得在过去90天内一直处于活动状态的帐户列表，总共花费在100美元到200美元之间。
这些用户不一定了解SQL，更重要的是，表连接，分组和聚合功能。
我一直在寻找使用Cube和DevExpress pivotgrid ：https：//www.devexpress.com/Products/NET/Controls/WinForms/Pivot_Grid/
我遇到的最大问题是控件无法给我MDX查询，以便我可以稍后重新运行查询。这也意味着我以后不能给控件一个MDX查询，以便用户可以更新它。
Telerek的pivotgrid有同样的问题。
还看了Korzh EasyQuery.Net：http：//devtools.korzh.com/easyquery/
我的问题在于您必须事先以xml文件的形式定义数据模型，因此如果底层架构发生更改，我们必须生成新的数据模型并进行部署。这也不能很好地支持聚合，你必须在生成数据模型时指定你想要聚合的内容。
我需要能够指出这个控件在运行时对任何数据库，它应该能够自己计算出可用的列等。
还有其他任何建议吗？
Can anyone please recommend an off the shelf (free or paid for) control (C# WinForms) that will give users drag and drop functionality to query data from any SQL database.
This purpose of this is for general segmentation. For example, a user might want to get a list of accounts that has been active in the last 90 days and has spent between $100 and $200 in total.
These users do not necessarily understand SQL, and more to the point, table joins, group by and aggregation functions.
I've been looking at using a Cube and the DevExpress pivotgrid: https://www.devexpress.com/Products/NET/Controls/WinForms/Pivot_Grid/
The biggest problem I am experiencing is that The control cant give me an MDX query so that I can re-run the query later. Which also means I cant later give the control an MDX query so that a user may update it.
Telerek's pivotgrid has the same problem.
Also looked at Korzh EasyQuery.Net: http://devtools.korzh.com/easyquery/
My issue here is that you have to define a data model in the form of a xml file beforehand, so if the underlying schema changes, we have to generate a new data model and deploy that. This also doesn't support aggregations very nicely, you have to specify what you would like to aggregate beforehand when generating the data model.
I need to be able to point this control to any database at run-time, and it should be able to work out the available columns etc. by itself.
Any other suggestions?
推荐答案
100和
总共200个。
这些用户没有必须理解SQL，更重要的是，表连接，分组和聚合功能。
我一直在寻找使用Cube和DevExpress pivotgrid：https ：//www.devexpress.com/Products/NET/Controls/WinForms/Pivot_Grid/
我遇到的最大问题是控件无法给我一个MDX查询，以便我以后可以重新运行查询。这也意味着我以后不能给控件一个MDX查询，以便用户可以更新它。
Telerek的pivotgrid有同样的问题。
还看了Korzh EasyQuery.Net：http：//devtools.korzh.com/easyquery/
我的问题在于您必须事先以xml文件的形式定义数据模型，因此如果底层架构发生更改，我们必须生成新的数据模型并进行部署。这也不能很好地支持聚合，你必须在生成数据模型时指定你想要聚合的内容。
我需要能够指出这个控制在运行时对任何数据库，它应该能够自己计算出可用的列等。
还有其他任何建议吗？
200 in total.
These users do not necessarily understand SQL, and more to the point, table joins, group by and aggregation functions.
I've been looking at using a Cube and the DevExpress pivotgrid: https://www.devexpress.com/Products/NET/Controls/WinForms/Pivot_Grid/
The biggest problem I am experiencing is that The control cant give me an MDX query so that I can re-run the query later. Which also means I cant later give the control an MDX query so that a user may update it.
Telerek's pivotgrid has the same problem.
Also looked at Korzh EasyQuery.Net: http://devtools.korzh.com/easyquery/
My issue here is that you have to define a data model in the form of a xml file beforehand, so if the underlying schema changes, we have to generate a new data model and deploy that. This also doesn't support aggregations very nicely, you have to specify what you would like to aggregate beforehand when generating the data model.
I need to be able to point this control to any database at run-time, and it should be able to work out the available columns etc. by itself.
Any other suggestions?
这篇关于现成的控件为非技术用户生成SQL查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
