CODEWITHSUNDEEP
c#.netsql-serverssms
CR41G14
CR41G14

Reputation: 5594

SQL Server query designer on C# application

I have been given the tasking of providing a desktop solution which allows a user to simply and safely create bespoke reporting queries where their knowledge of the database is limited.

Immediately what came to mind is the SQL server query designer in SSMS. I have searched the internet with no success of whether this can be integrated into a C# Windows Forms application. Has anyone had any success of invoking this functionality in C#?

Upvotes: 1

Views: 1018

Answers (1)

Nikitos
Nikitos

Reputation: 79

I used to work with Korzh's EasyQuery component in ASP.NET MVC, but they have the WinForms edition too.

It seems like exactly what you need - the database structure is hidden, end user operates with visual "conditions" and "columns", you get an SQL query as a result.

Here is the link: http://devtools.korzh.com/easyquery/

Upvotes: 2

Related Questions