API and Database Testing with Specflow and C#

Name: API and Database Testing with Specflow and C#
Rating: 4.3 (692 reviews)

Understanding and building API and database testing from groundup

Last updated 3/2016

English

English [Auto],

What you'll learn

3 sections • 10 lectures • 1h 43m total length

Introduction5:02
Introduce API concepts and testing with spec flow and C# in Visual Studio, outlining hosting options and using SoapUI and Postman for API testing.
Part 1 - Setting stage ready for API and Database Testing with Specflow and C#6:40
In this video we will be talking about Setting stage ready for API and Database Testing with Specflow and C#.

We will also talk about the functionality of EmployeeApp v1.0 and the PFService WCF application which we discussed in our Udemy course

Part 2 - Writing simple code to consume API service in console application16:12
Learn to consume a WCF web service from a console app, call endpoints to fetch employee contributions, and verify API responses reflect underlying business logic.
Part 3 - Understanding and writing simple test for API with C#6:11
Develop a simple test for a WCF API in C# using NUnit in Visual Studio, validating the employee contribution calculation (basic salary x 18% for 24 months) via unit tests.
Part 4 - Writing API test with Specflow C#11:22
Part 5 - Writing API test with Specflow C# (Cont)6:27
In this video we will talk about writing API test with Specflow C#. This video is a continuation of Part 4

Part 6 - Database testing of WCF API using Specflow and C#11:02
explains database testing of a WCF API with SpecFlow and C# by extending a test framework to verify employee contribution calculations via database updates and service responses.
Part 7 - Database testing of WCF API using Specflow and C# (Cont)11:07
In this video we will discuss working with Database Testing of WCF API using Specflow and C#. This video is a continuation of Part 6.
Part 8 - Database Testing for WCF API using SQL Stored Procedures11:49
In this video we will discuss how to test database of a WCF API using SQL Stored Procedures.

In this video we will write a simple Stored procedure which performs updation of existing data in a table from Specflow c#
Part 9 - Database testing of API with Mock Stored Procedure17:24
In this video we will be discussing about Database testing of API with Mock Stored Procedure using Specflow and C#

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

· 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