Implementing the database

In this section, we are going to create a SQL Server database for our Q&A app. We will then create tables in the database that will store questions and answers. After that, we will create stored procedures that read and write records in these tables.

Creating the database

We are going to create the database using SQL Server Management Studio (SSMS) by carrying out the following steps:

1. Open SSMS and connect to the SQL Server instance:

   Figure 8.1 – Connecting to SQL Server Express

2. In Object Explorer, right-click on Databases and click on the New Database... option.
3. Enter QandA for the name of the database and click OK:

   Figure 8.2 – Creating the Q&A database

4. Once the database has been created, we'll see it listed in Object Explorer:

Figure 8.3 – The Q&A database in Object Explorer...