public void GetProductCategoryById_IncludeParent_Success()
{
// Arrange
CreateTestData();
// Act
ProductCategory result;
using (var context = new TinyShoppingCartDbContext(_options))
{
context.Database.UseTransaction(_transaction);
var repository = new ProductCategoryRepository(context);
IQueryInclude queryObj = new QueryInclude {
IncludeProperties = "Parent"
};
result = repository.GetById(3, queryObj);
}
// Assert
Assert.NotNull(result);
Assert.Equal <int>(3, result.Id);
Assert.True(result.Name == "Clothes");
Assert.NotNull(result.Parent);
Assert.Equal <string>("Men", result.Parent.Name);
}
public void GetProductCategoryById_HaveTracking_Success()
{
// Arrange
CreateTestData();
// Act
ProductCategory result;
using (var context = new TinyShoppingCartDbContext(_options))
{
context.Database.UseTransaction(_transaction);
var repository = new ProductCategoryRepository(context);
IQueryInclude queryObj = new QueryInclude {
IsTracking = true
};
result = repository.GetById(3, queryObj);
result.Name = "Test";
context.SaveChanges();
result = repository.GetById(3, queryObj);
}
// Assert
Assert.NotNull(result);
Assert.Equal <int>(3, result.Id);
Assert.True(result.Name == "Test");
Assert.Null(result.Parent);
}
public ProductCategoryRepositoryFixture()
{
string connectionString = string.Format("Data Source=TinyShoppingCartDB_ProductCategoryTests_{0}.db", Guid.NewGuid());
Connection = new SqliteConnection(connectionString);
Connection.Open();
var builder = new DbContextOptionsBuilder <TinyShoppingCartDbContext>();
builder.UseSqlite(Connection);
ContextOptions = builder.Options;
_context = new TinyShoppingCartDbContext(ContextOptions);
_context.Database.EnsureCreated();
}
private void CreateTestData()
{
using (var context = new TinyShoppingCartDbContext(_options))
{
var dbSet = context.Set <ProductCategory>();
dbSet.Add(new ProductCategory {
Id = 1, Name = "Men"
});
dbSet.Add(new ProductCategory {
Id = 2, Name = "Women"
});
dbSet.Add(new ProductCategory {
Id = 3, Name = "Clothes", ParentId = 1
});
context.Database.UseTransaction(_transaction);
context.SaveChanges();
}
}
public void GetProductCategoryById_QueryObjectIsNull_Success()
{
// Arrange
CreateTestData();
// Act
ProductCategory result;
using (var context = new TinyShoppingCartDbContext(_options))
{
context.Database.UseTransaction(_transaction);
var repository = new ProductCategoryRepository(context);
result = repository.GetById(3);
}
// Assert
Assert.NotNull(result);
Assert.Equal <int>(3, result.Id);
Assert.True(result.Name == "Clothes");
Assert.Null(result.Parent);
}
public Repository(TinyShoppingCartDbContext dbContext) : base(dbContext)
{
}
public RepositoryWithTypedId(TinyShoppingCartDbContext dbContext)
{
_dbContext = dbContext;
_dbSet = dbContext.Set <TEntity>();
}
public UnitOfWork(TinyShoppingCartDbContext dbContext)
{
_dbContext = dbContext;
}
public ProductCategoryRepository(TinyShoppingCartDbContext dbContext) : base(dbContext)
{
}
