public void Test_EFRepository_CreateOrUpdate()
{
var options = new DbContextOptionsBuilder <ImmoContext>().UseInMemoryDatabase(databaseName: "Test_EFRepository_CreateOrUpdate").Options;
using (var context = new ImmoContext(options))
{
new ImmoSeeder(context).Seed();
var propertiesRepository = new EFReadWriteRepositoryBase <Property, Guid>(context);
propertiesRepository.DeleteById(SeedValues.Properties.MyApartmentWemmel.Id);
context.SaveChanges();
Assert.True(propertiesRepository.GetAll().Count() == 0);
propertiesRepository.CreateOrUpdate(SeedValues.Properties.MyApartmentWemmel);
var properties = propertiesRepository.GetAll();
var myApartment = propertiesRepository.GetById(SeedValues.Properties.MyApartmentWemmel.Id);
Assert.True(properties.Count() == 1);
Assert.True(myApartment.Id == SeedValues.Properties.MyApartmentWemmel.Id);
myApartment.OriginalURL = "test";
propertiesRepository.CreateOrUpdate(myApartment);
var myApartmentAfterUpdate = propertiesRepository.GetById(SeedValues.Properties.MyApartmentWemmel.Id);
Assert.True(myApartmentAfterUpdate.OriginalURL == myApartment.OriginalURL);
}
}
public void Test_EFRepository_Delete()
{
var options = new DbContextOptionsBuilder <ImmoContext>().UseInMemoryDatabase(databaseName: "Test_EFRepository_Delete").Options;
using (var context = new ImmoContext(options))
{
new ImmoSeeder(context).Seed();
var propertiesRepository = new EFReadWriteRepositoryBase <Property, Guid>(context);
propertiesRepository.DeleteByIds(new List <Guid> {
SeedValues.Properties.MyApartmentWemmel.Id
});
context.SaveChanges();
Assert.True(propertiesRepository.GetAll().Count() == 0);
}
}
public void Test_EFRepository_Get()
{
var options = new DbContextOptionsBuilder <ImmoContext>().UseInMemoryDatabase(databaseName: "Test_EFRepository_Get").Options;
using (var context = new ImmoContext(options))
{
new ImmoSeeder(context).Seed();
var propertiesRepository = new EFReadOnlyRepositoryBase <Property, Guid>(context);
var properties = propertiesRepository.GetAll();
var firstProperty = propertiesRepository.GetByIds(new List <Guid> {
SeedValues.Properties.MyApartmentWemmel.Id
}).FirstOrDefault();
Assert.True(properties.Count() == 1);
Assert.True(properties.First().Id == SeedValues.Properties.MyApartmentWemmel.Id);
Assert.True(firstProperty.Id == properties.FirstOrDefault().Id);
}
}
public EFReadOnlyRepositoryBase(ImmoContext dbContext)
{
this.DbContext = dbContext;
}
public EFReadWriteRepositoryBase(ImmoContext dbContext) : base(dbContext)
{
}
