You'll need the following hardware and software to build and run the code samples for this book:
Microsoft Windows XP Professional with Service Pack 2 (SP2), Windows Server 2003 with Service Pack 1 (SP1), or Windows 2000 with Service Pack 4 (SP4).
Visual Studio 2005 Standard Edition or Professional Edition. (The latter is required for Chapter 9 sample code.)
Microsoft SQL Server 2005 Express (included with Visual Studio 2005) and/or Microsoft SQL Server 2005. (See the next section.)
600 MHz Pentium or compatible processor (1 GHz Pentium recommended).
192 MB RAM (256 MB or more recommended).
800 x 600 or higher resolution video monitor with at least 256 colors (1024 x 768 High Color 16-bit recommended).
DVD-ROM drive.
Microsoft Mouse or compatible pointing device.
I have tried to use SQL Server 2005 Express Edition (SQL Server Express) where possible because it's easy to use. Further, SQL Server Express makes it easy to set up standalone samples because the database files can simply be included in the project. Some chapters use SQL Server 2005 because the features being covered are not available in SQL Server Express or because they are easier to use in SQL Server 2005.
The following table shows which release of SQL Server 2005 is used in the sample code, using these entries:
N/A Not applicable; database access not required
Yes Used in the code sample
No Not usable for the code sample
Possible Can optionally be used in place of the other version but requires connection string change
Chapter and Topics | SQL Server 2005 | SQL Server 2005 Express Edition |
---|---|---|
1: Overview of ADO.NET Disconnected Classes | N/A | N/A |
2: Overview of ADO.NET Connected Classes | Yes, Possible | Yes, Possible |
3: ADO.NET Trace Logging | Yes | No |
4: Advanced Connectivity to the Data Store | ||
|
|
|
|
|
|
|
|
|
|
|
|
5: Working with Disconnected Data | Possible | Yes |
6: Working with Relational Disconnected Data | Possible | Yes |
7: Working with the Windows Data Grid Control | Possible | Yes |
8: Working with the Web Data Grid Control | Possible | Yes |
9: Working with the SQLCLR | Yes | No |
10: Understanding Transactions | Possible | Yes |
11: Retrieving Metadata | Possible | Yes |
12: Data Caching for Performance | ||
|
|
|
|
|
|
|
|
|
13: Implementing Security | ||
|
|
|
|
|
|
|
|
|
|
|
|
14: Working with Large Objects (LOBs, BLOBs, and CLOBs) | Possible | Yes |
15: Working with XML Data | Possible | Yes |
This book requires that you have access to SQL Server 2005 Express Edition (and/or SQL Server 2005) to create and use the Northwind Traders and the Pubs sample databases. If you are using SQL Server 2005 Express, log in as Administrator on your computer, and follow these steps to grant access to the user account that you will use for performing the exercises.
On the Windows Start menu, click All Programs, Accessories, Command Prompt to open a command prompt window.
In the command prompt window, type the following command:
sqlcmd -S YourServer\SQLExpress -E
Replace YourServer with the name of your computer. You can find the name of your computer by running the hostname command in the command prompt window before running the sqlcmd command.
At the 1> prompt, type the following command, including the square brackets, and then press Enter:
SP_GRANTLOGIN [YourServer\UserName]
Replace YourServer with the name of your computer, and replace UserName with the name of the user account that you will be using.
At the 2> prompt, type the following command, and then press Enter:
GO
If you see an error message, make sure that you typed the SP_GRANTLOGIN command correctly, including the square brackets.
At the 1> prompt, type the following command, including the square brackets, and then press Enter:
SP_ADDSRVROLEMEMBER [YourServer\UserName], dbcreator
At the 2> prompt, type the following command, and then press Enter:
GO
If you see an error message, make sure that you typed the SP_ADDSRVROLEMEMBER command correctly, including the square brackets.
At the 1> prompt, type the following command, and then press Enter:
EXIT
Close the command prompt window.