how to execute "ExecuteSqlRawAsync" in in-memory database

Question

I am creating unit test case using x-unit and in-memory database and i am trying to execute the below line of code

await _dbContext.Database.ExecuteSqlRawAsync(lockSql, cancellationToken);

I am getting the below error : Relational-specific methods can only be used when the context is using a relational database provider.

How do i fix this and proceed with the test case?

user_2251733 · Answer

In-Memory Database has several issues that's why Microsoft prefers to use SQLite. In-Memory Database does not allow to run raw queries.