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)