ADO.NET  Examples and Best Practices
for C# Programmers
by William R. Vaughn with Peter Blackburn

Apress: Books for Professionals by Professionals ®

Up


Prerequisites

What Do I Need to Run the Examples on This CD?

The examples provided on this book's CD are designed for and tested with Microsoft SQL Server 2000 and Visual Studio.NET C#. To run the examples, you must have access to a SQL Server 2000 installation and install the test "Biblio" database. Yes, MSDE 2000 versions of SQL Server are fully capable of executing the examples. While some of the examples can be used with SQL Server 7.0, the Biblio database, stored procedures, and other database tables are designed for and with SQL Server 2000 and cannot be loaded by pre-SQL Server 2000 versions. The Biblio database requires about 350 MB of disk space. The Cover Pictures and Examples folders require another 69 MB.

To run any of the examples, you need:

bulletA Database Engine (Microsoft SQL Server 2000) with a SQL Server 2000 DBMS with the Biblio sample database installed. Yes, you can use MSDE version 2000.

SQL Server Links & UpdatesThis link requires a connection to the internet:
 

Because the examples are written in C#, you must have a version of Visual Studio .NET installed to test them. Microsoft has indicated that it will offer "free" versions of the .NET Framework and possibly Visual Studio on an evaluation basis which means the .NET Framework software only works for a limited length of time.

In order to test and evaluate the TSQL debugging feature, you must install the "Enterprise Architect" version of Visual Studio .NET--unless Microsoft changes its mind about this limitation.

To compile and test the examples, you need to install:

bulletVisual Studio .NET (7.0)
The Enterprise Architect version is only needed if you want to test/use TSQL Stored Procedure Debugging. Otherwise the Professional Edition should run all of the .NET examples on this CD.

Where do I find Visual Studio .NET?
   http://www.msdn.microsoft.com/downloads/ This link requires a connection to the internet
 
bulletOdbc .NET Data Provider (optional)
A few of the examples use the Microsoft.Data.Odbc .NET Data Provider. This is not included in the framework so you'll have to download it from www.msdn.microsoft.com/downloads or wherever Microsoft is hiding it.