For writing a unit testing for Repository layer, Which is the best approach

For writing a unit testing for Repository layer, Which is the best approach?
Like using Mockito(Mocking everything ) or Using in memory database to hit the database get result from it