SQL Server Unit Testing with C# and Specflow

As we move into DevOps centric world, it is becoming ever more important to have similar unit testing exaptation from SQL programmers as we have from other programmers.

Pre-Requisites

Visual Studio 2019

Select the following options during installation:

• Universal Windows Platform development
• .NET Core cross-platform development
• Data storage and processing

Visual Studio Extensions

Install following the Visual Studio Extensions, here are the steps.

• NUnit 3 Test Adapter
• SpecFlow for Visual Studio

.NET Core 3.1 SDK and Runtime

• Here is link to download - https://dotnet.microsoft.com/download/dotnet/current

Install SQL Server

• Install Sql Server Management Studio (SSMS)
• Setup your local database (SqlSampleDatabase)