want to write MS-Access like query builder in c?#

Question

Hi

we want to create MS-Access LIKE query parser where user can create complex queries having joins?

any thoughts on design in c#?

Answer 1

I would look at SQL Server Express (2008 or 2008 r2) and the management studio. With the Management Studio you can already create complex queries with joins (View Designer is an example). If you are looking for an end user product then I would look at reporting services that allows users to create reports and query data directly.

Answer 2

How about parsing SQL like strings to Linq? Read up on Linq Expressions. See here for a sample: SqlLinq: Taking LINQ to SQL in the Other Direction

Answer 3

It's not an easy task. It's much cheaper to use one that's already made. Active Query Builder - is a component written in C# to build and parse complex SQL queries.