在我的函数中有以下代码来从数据库中检索数据:
var oldFareSpecification = new ObservationOnOrBeforeDateSpecification(previousOutboundDate));
var oldFare = _fareRepository.Find(oldFareSpecification).SingleOrDefault();
规格为:
public class ObservationOnOrBeforeDateSpecification : Specification<Fare>
{
public ObservationOnOrBeforeDateSpecification(DateTime date)
: base(fh => EntityFunctions.DiffDays(fh.ObservationTS, date) >= 0)
{
}
}
使用System.Data.Entity.
存储库是
Repository<TEntity> : IRepository<TEntity>
private readonly DbContext _context;
private readonly DbSet<TEntity> _entitySet;
public IEnumerable<TEntity> Find(ISpecification<TEntity> criteria)
{
return criteria.SatisfyingEntitiesFrom(_entitySet).AsEnumerable();
}
它工作得很好,但是当我尝试在测试类中Moq存储库并调用存储库返回对我的假对象的查询结果时,我得到一个异常:函数只能从LINQ调用到实体(或者非常类似-我在其他语言中得到它:p)。
我的测试类使数据库以这种方式返回假结果:
var faresRepository = Fixture.Freeze<Mock<IRepository<DAL.Fare>>>();
faresRepository.Setup(
fhr => fhr.Find(It.IsAny<ISpecification<Fare>>())).Returns(
(ISpecification<Fare> spec) => spec.SatisfyingEntitiesFrom(fares.AsQueryable()));
,现在我的问题是,我如何编写规范,比较天的差异和工作良好,从代码正常调用和在模拟存储库。我这里所说的右比较是指,以天为单位的2013.01.16 23:55:34和2013.01.17 01:55:34之间的差值返回1.
解决方案:
**唯一的方法是创建一个队列,每次调用特定方法(这里是. find)时返回假结果。虽然不完全是我想要的,但至少是可行的。这里是:
var faresHistoryRepository = Fixture.Freeze<Mock<IRepository<DAL.FareHistory>>>();
var fareHistoryResults = new Queue<List<FareHistory>>();
var fareHistories = new List<DAL.FareHistory>();
FareHistory fh1 = new FareHistory { FareHistoryId = fareHistoryId + 1, FareId = fareId, ObservationTS = date.AddDays(-1), StatusId = (int)DAL.Enum.Status.Active };
fareHistories.Add(fh1);
fh1 = new FareHistory { FareHistoryId = fareHistoryId + 4, FareId = fareId, ObservationTS = date.AddDays(-4), StatusId = (int)DAL.Enum.Status.Active };
fareHistories.Add(fh1);
fh1 = new FareHistory { FareHistoryId = fareHistoryId + 5, FareId = fareId, ObservationTS = date.AddDays(-5), StatusId = (int)DAL.Enum.Status.Active };
fareHistories.Add(fh1);
fareHistoryResults.Enqueue(fareHistories); // fare histories
var fareHistoriesSample = new List<DAL.FareHistory>();
fh1 = new FareHistory { FareHistoryId = fareHistoryId + 6, FareId = oldFareId,
ObservationTS = depDate.AddDays(-fullDaysDifference), StatusId = (int)DAL.Enum.Status.Active };
fareHistoriesSample.Add(fh1);
fh1 = new FareHistory { FareHistoryId = fareHistoryId + 7, FareId = oldFareId,
ObservationTS = depDate.AddDays(-15), StatusId = (int)DAL.Enum.Status.Active };
fareHistoriesSample.Add(fh1);
fh1 = new FareHistory { FareHistoryId = fareHistoryId + 8, FareId = oldFareId,
ObservationTS = depDate.AddDays(-16), StatusId = (int)DAL.Enum.Status.Active };
fareHistoriesSample.Add(fh1);
fareHistoryResults.Enqueue(fareHistoriesSample); // fareHistoriesSample
faresHistoryRepository.Setup(
fhr => fhr.Find(It.IsAny<ISpecification<FareHistory>>
())).Returns(()=>fareHistoryResults.Dequeue());