tags:

views:

31

answers:

1
Q: 

Non Techie User Ad hoc LINQ query builder

Hi,

I am looking for a third party component which allows a non technical user to create simple adhoc LINQ queries by dragging and dropping the available fields and run it against a data model that I will be populating using Entity Framework. I've used http://devtools.korzh.com/eq/dotnet/ component previously to generate adhoc SQL queries but I want something similar for LINQ.

I am looking for only simple query generator, the most complex queries will include group by on couple of columns with summation on say revenue field(Or any measure field).

Do any of you guys know of any visually appealing tool already available in the market? If not then may be suggest an approach on how I can build it myself!

Many Thanks

Mithun

A: 

Best I have seen is LinqPad, its not the best "visual" query builder out there but it is pretty easy to test out LINQ queries.

alt text

Nix  2010-05-25 23:59:51
Thanks, I know and use LINQPad, it's a very good tool for someone technical like us. But I am looking for a drag and drop kind of tool for end users who have no clue what LINQ is, and behind the scenes that tool should generate LINQ query, so I can capture the query string and do whatever I have to do with it. I've googled/binged a lot to find something but unfortunately I couldn't find any. I might just have to write my own I guess.
Mithun Bose  2010-05-26 05:22:31

related questions

How to find an implementation of a C# interface in the current assembly with a specific name?
Learning about LINQ
LINQ to SQL Mapping From Money to Double
SQL Server 2008 vs 2005 Linq integration
Aging Data Structure in C#
LINQ-to-SQL vs stored procedures?
LINQ, entity that implements Interface and exception in mapping
How can I remove nodes from a SiteMapNodeCollection?
Conditional Linq Queries
LINQ query on a DataTable
Expression.Invoke in Entity Framework?
How to return a page of results from SQL?
Import Namespace System.Query
Has anyone run performance benchmarks comparing LINQ
Beginners Guide to LINQ
Querying like Linq when you don't have Linq.
Linq to objects - select first object
C# 3.0 Where extension method with lambda vs LINQtoObjects to filter in memory collections.
How much database performance overhead when using LINQ?
LinqDataSource - Can you limit the amount of records returned?
LINQ on the .NET 2.0 Runtime
How do I most elegantly express left join with aggregate SQL as LINQ query
How do you page a collection with LINQ?
How do I get a distinct, ordered list of names from a DataTable using Linq
How do I fill a DataSet or a DataTable from a LINQ query resultset ?