Query Builder

[robertfah]

I've been asked to create (or find) a Query builder for reuse in our company. The query builder should be able to make any type of query possible. I've got 2 questions for everyone:

1.) How hard would it be to create a query builder in Windows?

2.) Are there any components out there (besides Active Query Builder) that can be purchased?

Thanks for all the help!

 

[jmeckley]

1st. Do not build one. many exist, and this is actually a very difficult problem to solve. Unless your in the business of creating a query builder, don't.

I would go one step further and use an ORM (object relational mapper). ActiveRecord and NHibernate are 2 great OSS ORMs. If you have a budget for this LLBL Gen Pro is also a good ORM (excellent support). There are lesser known ORMs like WilsonOR and a few others.

I really love NHibernate and ActiveRecord. NH uses xml mapping files to map domain objects to database tables. ActiveRecord takes NH one step further by using attributes to decorate your domain objects, instead of the hassle of xml.

NH is great of legacy databases (not normalized). AR is great for normalized databases. The community surrounding these projects is very large and supportive.

Jason Meckley
Programmer
Specialty Bakers, Inc.

 

[deepsara]

Hi,

I hope my answer would possibly be a better solution for your trouble. Query Generator is a tool from wbcsoftwarelab. I am a .net programmer and having many such tiny readymade tools at my desk. I use this tool to insert/update/etc. to-fro master and client databases. Actually after downloading this, I have changed the sourcecode a little according to my requirement.

Reg. your questions -
1. See this sample to understand better for creating query generator projects.

2. Better surf the net.

View and reply dear.