Integration Testing with SQL Server and EF Core (11 of 12) | Automated Software Testing

Welcome to the Automated Software Testing series, where you will learn how to increase the efficiency and ROI of your software testing. Integration testing is testing how systems work together, beyond just a unit of work. In this episode, Phil Japikse discusses using xUnit to create automated integration tests for SQL Server and EF Core.

Chapters:
0:00 - Introduction
4:45 - Clearing and seeding sample data
6:05 - Initializing sample database
7:25 - Review of database call unit tests
13:25 - Testing concurrency exceptions
17:00 - Review of test helpers
19:10 - Wrapup

Resources:
https://github.com/skimedic/SoftwareT...

Episodes in this series:
Why Automated Software Testing Matters:
   • Why Automated Software Testing Matters (1 ...  

Testing with the xUnit Framework - Overview:
   • Testing with the xUnit Framework - Overvie...  

Testing with the xUnit Framework - Theories and Assertions:
   • Testing with the xUnit Framework - Theorie...  

Testing with the xUnit Framework - More Assertions:
   • Testing with the xUnit Framework - More As...  

BDD Style Testing with MSpec:
   • BDD Style Testing with MSpec (5 of 12) | A...  

Mocking Dependencies and Verifying Behavior - Moq Overview:
   • Mocking Dependencies and Verifying Behavio...  

Mocking Dependencies and Verifying Behavior - Applying Moq:
   • Mocking Dependencies and Verifying Behavio...  

Mocking Dependencies and Verifying Behavior - Additional Moq Features:
   • Mocking Dependencies & Verifying Behavior-...  

Running Unit Tests with Azure Pipelines:
   • Running Tests with Azure Pipelines (9 of 1...  

Running Unit Tests with GitHub Actions:
   • Running Unit Tests with GitHub Actions (10...  

Integration Testing with SQL Server and EF Core:
   • Integration Testing with SQL Server and EF...  

Web Application Testing with Microsoft’s Playwright:
   • Web Application Testing with Microsoft’s P...