CODEWITHSUNDEEP
c#integration-testingdbsetmockdbset
Bunty Choudhary
Bunty Choudhary

Reputation: 85

Entity Framework Core FromSqlRaw mock test cases

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?

Upvotes: 4

Views: 1972

Answers (1)

Backs
Backs

Reputation: 24913

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

Upvotes: 4

Related Questions