public class GenericRepository<T> : IGenericRepository<T> where T : BaseEntity
{
protected readonly DbContext DbContext;
public GenericRepository(DbContext dbContext)
{
DbContext = dbContext;
}
public string Create(T item)
{
if (string.IsNullOrEmpty(item.Id))
{
item.Id = Guid.NewGuid().ToString("N");
}
item.CreatedAt = DateTime.UtcNow;
DbContext.Entry(item).State = EntityState.Added;
DbContext.SaveChanges();
return item.Id;
/*using (var dbContext = new MyDbContext())
{
item.Id = Guid.NewGuid().ToString("N");
item.CreatedAt = DateTime.UtcNow;
dbContext.Entry(item).State = EntityState.Added;
dbContext.SaveChanges();
return item.Id;
}*/
}
public T GetById(string id)
{
return GetFirst(x => x.Id == id);
}
public T GetFirst(Expression<Func<T, bool>> @where, params Expression<Func<T, object>>[] nav)
{
return GetFiltered(nav).FirstOrDefault(where);
/*using (var context = new MyDbContext())
{
return GetFiltered(context, nav).FirstOrDefault(where);
}*/
}
private IQueryable<T> GetFiltered(params Expression<Func<T, object>>[] nav)
{
IQueryable<T> q = DbContext.Set<T>();
return nav.Aggregate(q, (current, n) => current.Include(n));
}
}
基于
microft's testing fundamental site
我试着写一些测试用例。
下面是单元测试代码
[TestClass]
public class GenericRepositoryTest
{
private Foo _foo;
private IQueryable<Foo> _fooList;
private Mock<DbSet<Foo>> _mockSet;
[TestInitialize]
public void Setup()
{
_foo = new Foo
{
EmailId = "foo@bar.com",
FirstName = "foo",
LastName = "bar",
ProfileId = 27,
IsDeleted = false,
};
_fooList = new List<Foo>
{
new Foo{EmailId = "one@bar.com", FirstName = "one", LastName = "bar", ProfileId = 28, IsDeleted = false},
new Foo{EmailId = "two@bar.com", FirstName = "two", LastName = "bar", ProfileId = 29, IsDeleted = false},
}.AsQueryable();
_mockSet = new Mock<DbSet<Foo>>();
_mockSet.As<IQueryable<Foo>>().Setup(m => m.Provider).Returns(_fooList.Provider);
_mockSet.As<IQueryable<Foo>>().Setup(m => m.Expression).Returns(_fooList.Expression);
_mockSet.As<IQueryable<Foo>>().Setup(m => m.ElementType).Returns(_fooList.ElementType);
_mockSet.As<IQueryable<Foo>>().Setup(m=>m.GetEnumerator()).Returns(_fooList.GetEnumerator());
}
[TestMethod]
public void Create_GivenEntity_ReturnsGuidId()
{
//Arrange
var guidId = Guid.NewGuid().ToString("N");
var dbContext = new Mock<MyDbContext>().Object;
IGenericRepository<Foo> genericRepository = new Mock<GenericRepository<Foo>>(dbContext).Object;
//Act
_waitingQueue.Id = guidId;
var actualId = genericRepository.Create(_foo);
//Assert
Assert.IsNotNull(actualId);
Assert.AreEqual(actualId, guidId);
}
[TestMethod]
public void GetById_GivenEntityId_ReturnsEntity()
{
//Arrange
var id = Guid.NewGuid().ToString("N");
_foo.Id = id;
var mockContext = new Mock<MyDbContext>();
mockContext.Setup(c => c.Foo).Returns(_mockSet.Object);
IGenericRepository<Foo> genericRepository = new Mock<GenericRepository<Foo>>(mockContext.Object).Object;
//Act
var fooId = genericRepository.Create(_foo);
var fooObject = genericRepository.GetById(id);
//Assert
fooObject.PropertiesShouldEqual(_foo);
}
}
这里是DbContext
public class MyDbContext : DbContext
{
public MyDbContext() : base("fakeConnectionString")
{
}
public virtual DbSet<Foo> WaitingQueues { get; set; }
}
我是新来的单元测试,我不知道我采取的方法是否正确。
目前,第一次测试
Create_GivenEntity_ReturnsGuidId
GetById_GivenEntityId_ReturnsEntity
失败。
我犯的错误是
GetFirst(Expression<Func<T, bool>> @where, params Expression<Func<T, object>>[] nav)
一般保存法
这是因为
GetFiltered(params Expression<Func<T, object>>[] nav)
被召唤时
GetFirst
返回空值。
是因为现在
T
GenericRepository<T>
?
我得到的错误是
System.ArgumentNullException
HResult=0x80004003
Message=Value cannot be null.
Parameter name: source
当我调试时我可以看到
GetById(string id)
方法已传入正确的id