Mock EF DbContext with SQLite for XUnit Test

DemoTests.cs

using Microsoft.Data.Sqlite;
using Microsoft.EntityFrameworkCore;
// ...

public static MyDbContext InMemoryContext()
{
    // SEE: https://docs.microsoft.com/en-us/ef/core/miscellaneous/testing/sqlite
    var connection = new SqliteConnection("Data Source=:memory:");
    var options = new DbContextOptionsBuilder<MyDbContext>()
        .UseSqlite(connection)
        .Options;
    connection.Open();
    
    // create the schema
    using (var context = new MyDbContext(options))
    {
        context.Database.EnsureCreated();
    }

    return new MyDbContext(options);

}