API and Database Testing with Specflow and C#

Understand what API testing is all about

Understand what database testing is

How to perform API and database testing with C#

Leverage the power of BDD in API and database testing


  • Good understanding on C#
  • Experience in working with automation framework (Since we will use one)
  • Basic concepts on BDD and Specflow as we use them as well


Understanding API and database testing with Specflow and C# course is designed in such a way that one can learn

· What are API and database testing

  • Understanding what are API
  • How to test API
  • How to test Databases

· Different tools available to perform API and database testing

o Will go through different tools available for API testing

· Why did we choose Visual studio as the tool for API and database testing

o Understand Visual studio for API testing

o How Visual studio helps in developing better codes

· Consuming a WCF API Web service using a Windows Console application from Visual Studio 2015

· Writing simple code to test the Web service with and without using Specflow C#

o Understand the power of Visual studio and Specflow to write code in Specflow C#

o Power of Specflow of automation testing and writing code with Specflow

· Connecting with Microsoft SQL database server to test data using simple queries

o Understand how to connect with SQL Server database via Visual studio code in C# language.

· Database testing using Stored procedures and C#

· Database testing using Mock stored procedure to test database data with API without user-defined data

· Finally, this course, is simple yet focused on the topic and yet easy to complete in a couple of hours

Who this course is for:

  • This course is for both testers and developers
  • Any manual test engineer with good knowledge in SQL can also learn this course

Course content

3 sections • 10 lectures • 1h 43m total lengthExpand all sections

Introduction to API and Database Testing2 lectures • 12min

  • Introduction05:02
  • Part 1 – Setting stage ready for API and Database Testing with Specflow and C#06:40

Writing code to consume and test API services4 lectures • 40min

  • Part 2 – Writing simple code to consume API service in console application16:12
  • Part 3 – Understanding and writing simple test for API with C#06:11
  • Part 4 – Writing API test with Specflow C#11:22
  • Part 5 – Writing API test with Specflow C# (Cont)06:27

Database testing for API services4 lectures • 51min

  • Part 6 – Database testing of WCF API using Specflow and C#11:02
  • Part 7 – Database testing of WCF API using Specflow and C# (Cont)11:07
  • Part 8 – Database Testing for WCF API using SQL Stored Procedures11:49
  • Part 9 – Database testing of API with Mock Stored Procedure17:24