Unit Testing with FakeDBSet and NBuilder

The Fastest Way To Mock a Database for Unit Testing

Create test data with NBuilder and Faker

Intro to .NET Unit & Integration Testing with SpecsFor  

you can Mock the DbSet and even use a nice Nuget’s package called FakeDbSet which has a InMemoryDbSet. 

.NET Engineering Guidelines 

One SQL unit testing framework which I have been using lately is tSQLt, which is a simple open-source framework.