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:

- Episodes in this series:
Why Automated Software Testing Matters:

Testing with the xUnit Framework - Overview:

Testing with the xUnit Framework - Theories and Assertions:

Testing with the xUnit Framework - More Assertions:

BDD Style Testing with MSpec:

Mocking Dependencies and Verifying Behavior - Moq Overview:

Mocking Dependencies and Verifying Behavior - Applying Moq:

Mocking Dependencies and Verifying Behavior - Additional Moq Features:

Running Unit Tests with Azure Pipelines:

Running Unit Tests with GitHub Actions:

Integration Testing with SQL Server and EF Core:

Web Application Testing with Microsoft’s Playwright:

[flygonfiasco]

Great stuff, thanks for the upload! I was wondering, when is the best time to run these tests. I think feedback should be provided frequently, but it sounds like these can be resource intensive