.Net Core Entity Framework core, using new database for each test in same test class

Question

I have a few tests to test the patching functionality. I am using this custom factory https://github.com/aspnet/Docs/blob/master/aspnetcore/test/integration-tests/samples/2.x/IntegrationTestsSample/tests/RazorPagesProject.Tests/CustomWebApplicationFactory.cs

For each test, I want to create new database or at-least clear and seed data again. Because other tests are messing up with data.

score 1 · Answer 1 · answered Mar 19 '19 at 23:20

1

You can use

 db.Database.EnsureDeleted();

This ensures that the database for the context does not exist. If it does not exist, no action is taken. If it does exist then the database is deleted.

answered Mar 19 '19 at 23:20

Peter Schneider

2,879
1
14
17

yeah I saw that somewhere, but not sure where exactly to use that. – user1630477 Mar 20 '19 at 15:29
In the factory mentioned above on line 44 - right before EnsureCreated() – Peter Schneider Mar 20 '19 at 15:49
yeah but that only runs once in the scope, when I run all tests in one file, it's under single scope, so test share the context and hence same data – user1630477 Mar 20 '19 at 17:33
Use IClassFixture - See [here](https://stackoverflow.com/questions/12976319/xunit-net-global-setup-teardown)... – Peter Schneider Mar 20 '19 at 18:13

.Net Core Entity Framework core, using new database for each test in same test class

1 Answers1