Efcore: DbContext Models are not cached throughout xUnit test run

Created on 20 Mar 2018 · 3Comments · Source: dotnet/efcore

See https://github.com/aspnet/EntityFrameworkCore/issues/1906#issuecomment-374352462

Here are the test results that I got.

The CacheTestClassXXX classes use a simplified version of the work around described in https://github.com/aspnet/EntityFrameworkCore/issues/1906#issuecomment-374320307.

Notice that only CacheTestClass1 had the overhead of DbContext model creation.
But the TestClassXXX classes all had the overhead.

Steps to reproduce

Create Class Library (.NET Framework 4.6.1) project.
Add Dependencies (Nuget)... see below for list of dependencies
Paste code below..
```C#
using Microsoft.Data.Sqlite;
using Microsoft.EntityFrameworkCore;
using System;
using Xunit;

public abstract class TestBase : IDisposable
{
private readonly SqliteConnection _connection;
protected readonly DbContextOptions _options;
public TestBase()
{
_connection = new SqliteConnection("DataSource=:memory:");
_connection.Open();
_options = new DbContextOptionsBuilder()
.UseSqlite(_connection)
.Options;
using (var context = new DbContext(_options))
{
context.Database.EnsureCreated();
}
}
public void Dispose()
{
_connection.Close();
}

[Fact]
public void DummyTestMethod() { }

}

public class TestClass1 : TestBase { }

public class TestClass2 : TestBase { }

public class TestClass3 : TestBase { }

[Collection(nameof(DbContextCache))]
public class CacheTestClass1 : TestBase { }

[Collection(nameof(DbContextCache))]
public class CacheTestClass2 : TestBase { }

[Collection(nameof(DbContextCache))]
public class CacheTestClass3 : TestBase { }

[CollectionDefinition(nameof(DbContextCache))]
public class DbContextCache : ICollectionFixture

Efcore: DbContext Models are not cached throughout xUnit test run

Steps to reproduce

Dependencies

Further technical details

Most helpful comment

All 3 comments

Related issues