Entity Framework Mocking using SQL Server LocalDB

NuGet

 Install-Package NeuroSpeech.EFLocalDBMock

Example For xUnit

using NeuroSpeech.EFLocalDBMock;


// Assuming you have `AppDbContext` as your EF DbContext in side your actual application project
// For test purposes, you will have to use AppDbTestContext 
// or you can use AppDbTestContext as dependency in your DI container
public class AppDbTestContext : AppDbContext {

	// this is important
	// since databases are dynamically created and destroyed
	// MockDatabaseContext.Current.ConnectionString contains 
	// correct database for current test context
	
	// MockDatabaseContext.Current will work correctly with async await
	// without worrying about passing context

	public AppDbTestContext(): base(MockDatabaseContext.Current.ConnectionString)
	{

	}
}

public class AppDbCleanMigrationConfiguration : DbMigrationsConfiguration<AppDbTestContext>
{
	public AppDbCleanMigrationConfiguration()
	{
		this.AutomaticMigrationDataLossAllowed = true;
		this.AutomaticMigrationsEnabled = true;
	}
}

public abstract class BaseTest: MockSqlDatabaseContext<AppDbTestContext, AppDbCleanMigrationConfiguration>
{

	public BaseTest(ITestOutputHelper writer)
	{
		this.Writer = writer;
	}

	protected override void DumpLogs()
	{
		this.Writer.WriteLine(base.GeneratedLog);
	}

	public ITestOutputHelper Writer { get; private set; }
}

Now you can derive all your tests from BaseTest and you can use AppDbTestContext