Effective Search Tools and Techniques for Your Business Applications

Summary

We spent a great deal of time discussing the SqlQuery tool in this chapter, but I think you’ll find that an object-oriented SQL query builder can definitely save you a lot of time and hassle in certain situations. As mentioned before, the SqlQuery tool is by no means a complete solution. There are still certain keywords and clauses that it does not support, and you can always add more common search functionality to it as you find the need.

You also learned a great deal about paging using the new features in the features in SQL Server 2005, which should help you make your data applications more efficient. Paged data can definitely boost performance for most applications, and the SqlQuery tool makes using paged data a breeze. It also makes it easier for your users to look through large sets of data.

Finally, you learned how to build search forms and how to make interchangeable forms to give users advanced and simple search options. People definitely appreciate flexibility, so these types of features can help boost user acceptance and the overall usability of an application.