Time for action – Creating the database
First, we will manually create an empty new database and then we will add code to our application, which allows us to delete and recreate the database schema.
- Open the Microsoft SQL Server Management Studio (SSMS), which was installed as part of the MS SQL Server Express setup. When asked for the connection details, enter .\SQLExpress as the server name and choose Windows Authentication as the authentication mode. This is shown in the following screenshot:
If you are accessing your locally installed SQL Server Express edition, then you can also use the alias
(local) instead of
.\SQLExpress to connect to your ...