Using Entity Framework Core for Data Access & Relational Mapping/

...

/

Testing with SQLite

Testing with SQLite

Learn the basics of testing EF Core applications using SQLite.

We'll cover the following...

Overview

Testing allows us to determine whether our applications work correctly and quickly notifies us if the application’s behavior regresses.

Note: This lesson discusses testing EF Core applications using SQLite, which has an in-memory database feature that is ideal for testing. The SQLite process isolates each test in its own in-memory database, and no actual files are managed.

We’ll demonstrate using the C# project below:

{
    "version": "0.2.0",
    "configurations": [
        {
            // Use IntelliSense to find out which attributes exist for C# debugging
            // Use hover for the description of the existing attributes
            // For further information visit https://github.com/OmniSharp/omnisharp-vscode/blob/master/debugger-launchjson.md
            "name": ".NET Core Launch (console)",
            "type": "coreclr",
            "request": "launch",
            "preLaunchTask": "build",
            // If you have changed target frameworks, make sure to update the program path.
            "program": "${workspaceFolder}/Artists/bin/Debug/net6.0/Artists.dll",
            "args": [],
            "cwd": "${workspaceFolder}/Artists",
            // For more information about the 'console' field, see https://aka.ms/VSCode-CS-LaunchJson-Console
            "console": "internalConsole",
            "stopAtEntry": false
        },
        {
            "name": ".NET Core Attach",
            "type": "coreclr",
            "request": "attach"
        }
    ]
}
Testing using SQLite in-memory mode

Click the “Run” button above, then execute the command below in the terminal:

Press + to interact
dotnet test

Below is a snippet from the output:

Press + to interact
One test file matched the specified pattern.
Passed!  - Failed:     0, Passed:     1, Skipped:     0, Total:     1, Duration: < 1 ms - Artists.Test.dll (net6.0)

Line 3 above indicates that one test ran and one test passed.

Setup

The SPA widget above contains two projects titled Artists and Artists.Test. Note the following:

  • Artists is the main project. It contains the following: ...