As for the database that is used in the samples, it also can be found at http://www.dominiondigital.com/AspNetCookbook/. The database used for all samples is a SQL Server 2000 database.
As you browse the different sample programs throughout the book, you will see that our preferred method of data access is OLE DB. From our experience writing applications for corporate clients , we have learned that many projects start out using SQL Server but migrate to other database servers, such as Oracle or DB2, during the life of the project. By using OLE DB for data access, we gain the necessary layer of abstraction to easily switch database platforms when and if we need to without having to change the underlying source code. Nevertheless, when you know that SQL Server will be your database platform for the long run, you will undoubtedly want to use SQL Provider to improve its performance, and Recipe 16.4 will show you how.
The connection string used in the samples throughout the book is shown next . It designates the server as localhost , the database as ASPNetCookbook , the database user as ASPNetCookbook_User , and the password for the user as w0rk . You will need to change these parameters to conform to your database installation.
Provider=SQLOLEDB;Data Source=localhost; Initial Catalog=ASPNetCookbook; UID=ASPNetCookbook_User; PWD=w0rk"