Effort - testy Entity Framework

BaseTests.cs

public class BaseTests : RepositoryTests
{
    protected ProductRepository Create(string path = null)
    {
        var context = CreateContext(path);

        return new ProductRepository(new Lazy<DataContext>(() => context));
    }
}

DataContext.cs

public class DataContext : DbContext
{
    public DataContext()
        : base("Name=DefaultConnection")
    {
    }

    public DataContext(DbConnection connection)
        : base(connection, true)
    {
    }

    public DbSet<Product> Products { get; set; }
}

GetAllActiveTests.cs

public class GetAllActiveTests : BaseTests
{
    [Fact]
    public void Return_Only_Active_Products()
    {
        var repository = Create();

        var products = repository.GetAllActive();

        products.Should().NotBeNull();
        products.Count().Should().Be(9);
        products.Should().OnlyContain(p => p.IsActive);
    }

    [Fact]
    public void Return_Empty_Collection()
    {
        var repository = Create(@"ProductRepositoryTests\Data\NoActiveProducts");

        var products = repository.GetAllActive();

        products.Should().NotBeNull();
        products.Count().Should().Be(0);
    }
}

Model.cs

public class Model
{
    public Model()
    {
        IsActive = true;
    }

    public int Id { get; set; }

    public bool IsActive { get; set; }
}

Product.cs

public class Product : Model
{
    public string Name { get; set; }
}

ProductRepository.cs

public class ProductRepository
{
    private Lazy<DataContext> _db;

    protected DataContext Db
    {
        get { return _db.Value; }
    }

    public ProductRepository(Lazy<DataContext> db)
    {
        _db = db;
    }

    public IEnumerable<Product> GetAllActive()
    {
        return Db.Products
            .Where(p => p.IsActive)
            .ToList();
    }
}

query.sql

SELECT *
  FROM [dbo].[Products]
  where IsActive = 0

RepositoryTests.cs

public class RepositoryTests
{
    protected DataContext CreateContext(string path = null)
    {
        IDataLoader loader = new CsvDataLoader(path ?? "Data");

        return new DataContext(DbConnectionFactory.CreateTransient(loader));
    }
}