With our database now in SQL Server, let's take a look at some techniques we can use to access it. In this example we'll use many of the techniques we've already discussed to pull catalog data from our new data source. So far, we have seen how to get data from a data source using various objects. In this example we'll take a look at retrieving information concerning the data source itself.
The MAP Example is designed to present us with a listing of all the tables it finds in a SQL Server database we specify. We then have the option of selecting a table, and seeing its structure. The source code for this example is available for download with the other samples, from our Web site at: http://rapid.wrox.com/books/0723/.