转换IQueryable< T>到DbSet< T> [英] Converting an IQueryable<T> to a DbSet<T>

问题描述

我不确定这是否可行，但是我试图对使用DbSet的存储库进行单元测试.我以为最简单的解决方案就是创建一个Enumerable，然后用它替换DbSet，这是我的尝试.

I'm not sure that this is possible, but I'm trying to unit test a repository that uses a DbSet. I thought the easiest solution would just be to make an Enumerable, and replace the DbSet with that, this is my attempt.

我正在使用C#，EntityFramework，XUnit和Moq

I'm using C#, EntityFramework, XUnit, and Moq

[Fact]
public void SomeTest() 
{
    //arrange
    var mockContext = new Mock<MyDbContext>();
    var mockData = new List<Person>
        {
            new Person { Name = "Jim", Age = 47 }
        };
    mockContext.Setup(db => db.Persons).Returns((DbSet<Person>)mockData.AsQueryable());

    var repo = PersonRepository(mockContext.Object); 

    //act
    var result = repo.GetByFirstName("Jim");

    //assert
    //do some assertion
}

引发的错误是它无法将EnumerableQuery类型转换为模拟上下文.返回语句上的DbSet.

The error that gets thrown is it can't convert type EnumerableQuery to a DbSet on the mockContext.Returns statement.

这与界面的外观相似.

PersonRepository.cs

public class PersonRepository: EFRepository<Person>, IPersonRepository
{
    public PersonRepository(DbContext dbContext) : base(dbContext)
    {
    }

    public IQueryable<Link> GetByFirstName(string name)
    {
        return DbSet.Where(p => p.FirstName == name);
    }
}

IPersonRepository.cs

public interface IPersonRepository: IRepository<Person>
{
    IQueryable<Person> GetByFirstName(string name);
}

IRepository.cs

public interface IRepository<T> where T : class 
{
    IQueryable<T> GetAll();
    T GetById(int id);
    void Add(T entity);
    void Delete(T entity);
    void Delete(int id);
    void Update(T entity);
}

EFRepository.cs

public class EFRepository<T> : IRepository<T> where T : class
{
    protected DbContext DbContext { get; set; }
    public IDbSet<T> DbSet { get; set; }

    public EFRepository(DbContext dbContext)
    {
        if (dbContext == null)
            throw new ArgumentNullException("dbContext");

        DbContext = dbContext;
        DbSet = DbContext.Set<T>();
    }
    ...
}

推荐答案

您可以做的是将Linq表达式从存储库移到业务逻辑中，然后模拟存储库.

What you can do is to move the Linq expression from your repository into the business logic and mock the repository instead.

public interface IPersonRepository : IRepository<Person>
{
    IQueryable<Person> GetAll { get; }
}

public class PersonRepository : EFRepository<Person>, IPersonRepository
{
    // ...

    public IQueryable<Person> GetAll
    {
        get { return DbSet; }
    }
}

public class SomeBusinessLogicClass
{
    private readonly IPersonRepository _people;

    public SomeBusinessLogicClass(IPersonRepository people)
    {
        _people = people;
    }

    public IEnumerable<Person> GetByFirstName(string name)
    {
        return _people.GetAll.Where(p => p.FirstName == name);
    }
}

现在重写测试以验证业务逻辑.

Now rewrite your test to validate the business logic.

[Fact]
public void SomeTest() 
{
    //arrange
    var mockRepository = new Mock<IPersonRepository>();
    var mockData = new List<Person>
        {
            new Person { Name = "Jim", Age = 47 }
        };
    mockRepository.Setup(x => x.GetAll).Returns(mockData);

    var bl = new SomeBusinessLogicClass(mockRepository.Object); 

    //act
    var result = bl.GetByFirstName("Jim");

    //assert
    //do some assertion
}

这篇关于转换IQueryable< T>到DbSet< T>的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！