How to set up the DbContext in xUnit test project properly?

Question

I have the following code to set up DBContext in the .Net core 2.0 console program and it's injected to the constructor of the main application class.

 IConfigurationRoot configuration = GetConfiguration(); services.AddSingleton(configuration); Conn = configuration.GetConnectionString("ConnStr1"); services.AddDbContext<MyDbContext>(o => o.UseSqlServer(Conn));

Now I created a xUnit test class and need to initialize the same DbContext for testing.

 context = new MyDbContext(new DbContextOptions<MyDbContext>());

It gets the error of the parameter connectionString cannot be null. How to set up the DbContext in test project properly?

You just need to set options for it. As example this option are used to store db in the memory: var optionsBuilder = new DbContextOptionsBuilder<MyDbContext>(); optionsBuilder.UseInMemoryDatabase(); var context = new MyDbContext(optionsBuilder.Options); — George Alexandria
– George Alexandria, Commented Sep 14, 2017 at 21:10

ca9163d9 · Accepted Answer · 2017-09-14 21:09:12Z

14

I found a way to do it.

var dbOption = new DbContextOptionsBuilder<MyDbContext>() .UseSqlServer("....") .Options;

answered Sep 14, 2017 at 21:09

ca9163d9

29.6k74 gold badges252 silver badges466 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Sam Over a year ago

For others looking, the other solutions are slightly more complete in that they initialize the context too!

jsuvanto · Accepted Answer · 2020-05-27 04:35:23Z

10

The George Alexandria's solutions work for me:

var optionsBuilder = new DbContextOptionsBuilder<MyDbContext>(); optionsBuilder.UseInMemoryDatabase(); var context = new MyDbContext(optionsBuilder.Options);

The UseInMemoryDatabase extension method is included in Microsoft.EntityFrameworkCore.InMemory

edited May 27, 2020 at 4:35

jsuvanto

34 bronze badges

answered Dec 18, 2017 at 16:12

re_al_

1311 silver badge5 bronze badges

2 Comments

Kelby Criswell Over a year ago

For those who use this more complete method, don't forget to either use 'context.dispose()' or a using bracket i.e. using (var context = new MyDbContext(optionsBuilder.Options)){ // Your code here}.

DavidY Over a year ago

Do you have configuration using fluent API? It seems the ModelBuilder is no available for the OnModelCreating(ModelBuilder modelBuilder) beucase it is supplied with DI from ASP.Net. Is there a way to supply the ModelBuilder for the DBContext in a testing project?

hada · Accepted Answer · 2020-01-15 15:58:30Z

EF 2.0 requires that all in-memory database are named, so be sure to name it like so:

var optionsBuilder = new DbContextOptionsBuilder<MyDbContext>(); optionsBuilder.UseInMemoryDatabase("MyInMemoryDatabseName"); var context = new MyDbContext(optionsBuilder.Options);

Collectives™ on Stack Overflow

How to set up the DbContext in xUnit test project properly?

3 Answers 3

1 Comment

2 Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

2 Comments

Comments

Related