Summary

In this chapter, you learned how to create search pages with ADO.NET. In the first part, you learned how to work with the Microsoft SQL Server Full-Text Search Service to search through data stored in a database table. You learned how to perform both free text and Boolean queries. You also learned how to store and index binary documents ”such as Microsoft Word documents and PowerPoint presentations ”in an image column.

Next, you learned how to work with the Microsoft Indexing Service. You examined how to use the OLE DB Provider for Indexing Service with ADO.NET. You learned about the standard document properties supported by the Indexing Service and how to perform both free text and Boolean queries against documents stored in the file system.