System.InvalidOperationException: Relational-specific methods can only be used when the context is using a relational database provider

entity-framework unit-testing xunit in-memory-database
Taufik Shaikh picture Taufik Shaikh · May 23, 2018 · Viewed 8.3k times · Source

System.InvalidOperationException:

Relational-specific methods can only be used when the context is using a relational database provider.

Getting the above mentioned error while using InMemoryDatabase for Test Case?

var msaContextOptions = new DbContextOptionsBuilder<MSA.DAL.MsaDbContext>()
           .UseInMemoryDatabase(databaseName: "Get results")
           .ConfigureWarnings(w => w.Ignore(InMemoryEventId.TransactionIgnoredWarning))
           .Options;

Answer

Hemant Sakta picture Hemant Sakta · Jul 30, 2019

As mentioned by other people I found skipping DBMigration is the best option for now. I am running Database Migration when Database ProviderName is not InMemory.

if (context.Database.ProviderName != "Microsoft.EntityFrameworkCore.InMemory")
{
    context.Database.Migrate();
}

Related questions

How are people unit testing with Entity Framework 6, should you bother?

I am just starting out with Unit testings and TDD in general. I have dabbled before but now I am determined to add it to my workflow and write better software. I asked a question yesterday that kind of included …

Read More
"Cannot drop database because it is currently in use". How to fix?

Having this simple code I get "Cannot drop database "test_db" because it is currently in use" (CleanUp method) as I run it. [TestFixture] public class ClientRepositoryTest { private const string CONNECTION_STRING = "Data Source=.;Initial Catalog=test_db;Trusted_Connection=…

Read More
Why DbContext doesn't implement IDbContext interface?

Why there is no IDbContext interface in the Entity Framework? Wouldn't it be easier to test things if there was an existing interface with methods like SaveChanges() etc. from which you could derive your custom database context interface? public interface …

Read More