Setting up our sample database

In this chapter, we will be demonstrating the difference between how different collection interfaces handle data. For our demonstrations, we require access to database data. To do so, we will create a database, add a table to it, and populate it with data. We will use SQL Server for our database engine and SQL Server Management Studio to develop our sample database.

To add our database, follow these steps:

1. Open SQL Server Management Studio and connect to your database engine.
2. Right-click on the Databases folder in Object Explorer, as shown in the following screenshot:

Figure 6.1 – SQL Server Management Studio – Object Explorer

3. Select New Database from the context menu. This will display the New Database dialog, as shown in the following screenshot:

Figure 6.2 – SQL Server Management Studio – the New Database dialog

4. Once you have entered SampleData...