Entity Framework Core FromSqlRaw mock test cases

Question

I am creating a integration test for api method which have some query like below

public async static Task<IEnumerable<T>> ForSysAll<T>(this DbSet<T> dbSet,int id) where T : class
{
    return await dbSet.FromSqlRaw($"SELECT * FROM dbo.TableName Where Id = {0}",id).ToListAsync();
}

This is working fine while I run with API code. But when I am trying to debug/run with test case. It throws an exception which is :- System.NotImplementedException : Unhandled method: FromSqlOnQueryable

Can anyone having any idea for this?

Answer 1

InMemory database is not a relational database and doesn't support raw SQL execution. Link.