var builder = new DbContextOptionsBuilder<MyDbContext>();
builder.UseSqlServer("Server=.;Database=404;Connection Timeout=1;Command timeout=1");
using var ctx = new MyDbContext(builder.Options);
var action = () => ctx.AnyTable.FirstOrDefault();
action.Should().ThrowExactly<SqlException>().WithMessage(
    "A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: TCP Provider, error: 40 - Could not open a connection to SQL Server)");

var interfacesSets = typeof(IMyDBContext).GetProperties().Select(x => x.Name);
var implementationSets = typeof(MyDBContext)
    .GetProperties(BindingFlags.DeclaredOnly | BindingFlags.Instance | BindingFlags.Public)
    .Select(x => x.Name);
string.Join(' ', implementationSets.Except(interfacesSets)).Should().BeEmpty();

[Configuration("persistence")]
public class PersistenceConfiguration
{
    public SqlServerConfiguration SqlServer { get; set; }
    public SmbConfiguration Smb { get; set; }
}

public class PersistenceTests
{
    private MyDbContext _myDbContext;

    [SetUp]
    public void SetUp()
    {
        var contextOptions = new DbContextOptionsBuilder<MyDbContext>()
            .UseInMemoryDatabase("test")
            .Options;

        _myDbContext = new MyDbContext(contextOptions);
    }

    [Test]
    public void ValidateEntityRelationships()
    {
        _myDbContext.GetContext().Should().NotBeNull().And.BeOfType<MyDbContext>();
        var entityTypes = _myDbContext.Model.GetEntityTypes();
        foreach (var entityType in entityTypes)
        {
            // We need the class reference to construct the method call
            var reference = typeof(PersistenceTests);

            // We need the name of generic method to call using the class reference
            var methodInfo = reference.GetMethod("AssertFirstOrDefaultIsNull",
                BindingFlags.Instance | BindingFlags.NonPublic);

            // This creates a callable MethodInfo with our generic type
            var miConstructed = methodInfo.MakeGenericMethod(entityType.ClrType);

            // This calls the method with the generic type using Invoke
            miConstructed.Invoke(this, null);
        }
        // stored procedures are not supported by the inMemoryDatabase and thus can't be verified here
    }

#pragma warning disable S1144
#pragma warning disable IDE0051
    /// <summary>
    /// This is called via reflection because of that we need to pragma warning disable the linter
    /// This method is needed since there is not _myDbContext.Set(Type type) method anymore in ef core
    /// </summary>
    /// <typeparam name="T"></typeparam>
    private void AssertFirstOrDefaultIsNull<T>() where T : class
    {
        _myDbContext.Set<T>().FirstOrDefault().Should().BeNull();
    }
#pragma warning restore S1144
#pragma warning restore IDE0051
}