public static async Task<MEntity> CreateMEntityWithSomeNEntites()
{
var mEntity = new MEntity
{
Name = "MEntityWithSomeNEntities " + DateTime.Now,
ObjectState = EObjectState.Added
};
var firstNEntity = new NEntity
{
Name = "FirstRelatedNEntity " + DateTime.Now,
ObjectState = EObjectState.Added
};
var secondNEntitiy = new NEntity
{
Name = "SecondRelatedNEntity " + DateTime.Now,
ObjectState = EObjectState.Added
};
mEntity.NEntities.Add(firstNEntity);
mEntity.NEntities.Add(secondNEntitiy);
using (IDataAccessor dataAccessor = new DataAccessor(DbContextFactory))
{
dataAccessor.InsertOrUpdate(mEntity);
await dataAccessor.SaveChangesAsync();
}
return mEntity;
}
public async Task UpdateMEntityAddNewNEntity()
{
const string newNEntityName = "UpdateMEntityAddNewNEntity - newNEntity";
var mEntity = await DatabaseInitializeHelper.CreateSimpleMEntity();
var newNEntity = new NEntity
{
Name = newNEntityName,
ObjectState = EObjectState.Added
};
mEntity.NEntities.Add(newNEntity);
mEntity.ObjectState = EObjectState.Modified;
using (IDataAccessor dataAccessor = new DataAccessor(_dbContextFactory))
{
dataAccessor.InsertOrUpdate(mEntity);
Assert.IsTrue(dataAccessor.HasPendingChanges, "HasPendingChanges should be true!");
await dataAccessor.SaveChangesAsync();
Assert.IsFalse(dataAccessor.HasPendingChanges, "HasPendingChanges should be false directly after Saving!");
}
using (IDataAccessor dataAccessor = new DataAccessor(_dbContextFactory))
{
var loadedMEntity = await dataAccessor.GetSingleAsync<MEntity>(mE => mE.Id.Equals(mEntity.Id), mE => mE.NEntities);
Assert.AreEqual(1, loadedMEntity.NEntities.Count);
Assert.AreEqual(newNEntityName, loadedMEntity.NEntities.First().Name);
}
}
public static async Task<NEntity> CreateSimpleNEntity()
{
var newNEntity = new NEntity
{
Name = "Simple NEntity " + DateTime.Now,
ObjectState = EObjectState.Added
};
using (IDataAccessor dataAccessor = new DataAccessor(DbContextFactory))
{
dataAccessor.InsertOrUpdate(newNEntity);
await dataAccessor.SaveChangesAsync();
}
return newNEntity;
}
public async Task InsertMEntityWithSomeNEntities()
{
const string mEntityName = "InsertMEntityWithSomeNEntities - Parent MEntity";
const string firstNEntityName = "InsertMEntityWithSomeNEntities - First NEntity";
const string secondNEntityName = "InsertMEntityWithSomeNEntities - Second NEntity";
var mEntity = new MEntity
{
Name = mEntityName,
ObjectState = EObjectState.Added
};
var firstNEntity = new NEntity
{
Name = firstNEntityName,
ObjectState = EObjectState.Added
};
var secondNEntitiy = new NEntity
{
Name = secondNEntityName,
ObjectState = EObjectState.Added
};
mEntity.NEntities.Add(firstNEntity);
mEntity.NEntities.Add(secondNEntitiy);
using (IDataAccessor dataAccessor = new DataAccessor(_dbContextFactory))
{
dataAccessor.InsertOrUpdate(mEntity);
Assert.IsTrue(dataAccessor.HasPendingChanges, "HasPendingChanges should be true!");
await dataAccessor.SaveChangesAsync();
Assert.IsFalse(dataAccessor.HasPendingChanges, "HasPendingChanges should be false directly after Saving!");
}
using (IDataAccessor dataAccessor = new DataAccessor(_dbContextFactory))
{
Assert.IsTrue(await dataAccessor.Set<MEntity>().AnyAsync(mE => mE.Name.EndsWith(mEntityName)));
var loadedMEntity = await dataAccessor.GetSingleAsync<MEntity>(entity => entity.Name.EndsWith(mEntityName),
entity => entity.NEntities);
Assert.AreEqual(2, loadedMEntity.NEntities.Count);
Assert.IsTrue(loadedMEntity.NEntities.Any(nE => nE.Name.Equals(secondNEntityName)));
Assert.IsTrue(loadedMEntity.NEntities.Any(nE => nE.Name.Equals(firstNEntityName)));
}
}
public async Task UseNestedDataAccessors()
{
var mEntity = await DatabaseInitializeHelper.CreateSimpleMEntity();
var nEntity = new NEntity
{
Name = "UseNestedDataAccessors - new NEntity",
ObjectState = EObjectState.Added
};
var otherEntity = new OtherEntity
{
Name = "UseNestedDataAccessors - new OtherEntity",
ObjectState = EObjectState.Added,
NEntity = nEntity,
NEntityId = nEntity.Id
};
using (IDataAccessor dataAccessor = new DataAccessor(_dbContextFactory))
{
dataAccessor.InsertOrUpdate(nEntity);
dataAccessor.ModifyRelatedEntities(mEntity, mE => mE.NEntities, EntityState.Added, nEntity);
Assert.IsTrue(dataAccessor.HasPendingChanges, "HasPendingChanges should be true!");
using (IDataAccessor secondDataAccessor = new DataAccessor((DataAccessorBase)dataAccessor))
{
secondDataAccessor.InsertOrUpdate(otherEntity);
Assert.IsTrue(dataAccessor.HasPendingChanges, "HasPendingChanges should be true!");
await secondDataAccessor.SaveChangesAsync();
Assert.IsFalse(secondDataAccessor.HasPendingChanges, "HasPendingChanges should be false directly after Saving!");
}
}
using (IDataAccessor dataAccessor = new DataAccessor(_dbContextFactory))
{
var reloadedMEntity =
await
dataAccessor.GetSingleAsync<MEntity>(mE => mE.Id.Equals(mEntity.Id), mE => mE.NEntities,
mE => mE.NEntities.Select(nE => nE.OtherEntities));
Assert.IsTrue(reloadedMEntity.NEntities.Any(nE => nE.Id.Equals(nEntity.Id)));
Assert.AreEqual(1, reloadedMEntity.NEntities.Count);
Assert.IsTrue(reloadedMEntity.NEntities.First().OtherEntities.Any(oE => oE.Id.Equals(otherEntity.Id)));
}
}
public async Task MultipleRelationModificationsBeforeSave()
{
const string newNEntityName = "MultipleRelationModificationsBeforeSave - newNEntity";
var mEntity = await DatabaseInitializeHelper.CreateMEntityWithSomeNEntites();
var existingNEntity = await DatabaseInitializeHelper.CreateNEntityWithSomeOtherEntities();
var newNEntity = new NEntity
{
Name = newNEntityName,
ObjectState = EObjectState.Added
};
//Add both Entities to the ObjectList in the Domainmodel
mEntity.NEntities.Add(newNEntity);
mEntity.ObjectState = EObjectState.Modified;
using (IDataAccessor dataAccessor = new DataAccessor(_dbContextFactory))
{
dataAccessor.InsertOrUpdate(mEntity);
dataAccessor.ModifyRelatedEntities(mEntity, mE => mE.NEntities, EntityState.Added, existingNEntity);
dataAccessor.ModifyRelatedEntities(mEntity, mE => mE.NEntities, EntityState.Deleted, existingNEntity);
Assert.IsTrue(dataAccessor.HasPendingChanges, "HasPendingChanges should be true!");
await dataAccessor.SaveChangesAsync();
Assert.IsFalse(dataAccessor.HasPendingChanges, "HasPendingChanges should be false directly after Saving!");
}
using (IDataAccessor dataAccessor = new DataAccessor(_dbContextFactory))
{
var reloadedMEntity = await dataAccessor.GetSingleAsync<MEntity>(mE => mE.Id.Equals(mEntity.Id), mE => mE.NEntities);
var reloadedNEntity = await dataAccessor.GetSingleAsync<NEntity>(nE => nE.Id.Equals(existingNEntity.Id), nE => nE.MEntities);
Assert.AreEqual(3, reloadedMEntity.NEntities.Count);
Assert.AreEqual(0, reloadedNEntity.MEntities.Count);
}
}
public async Task InsertNEntityWithSomeOtherEntities()
{
const string nEntityName = "InsertNEntityWithOtherEntities - NEntity";
const string firstOtherEntityName = "InsertNEntityWithOtherEntities - FirstOtherEntity";
const string secondOtherEntityName = "InsertNEntityWithOtherEntities - SecondOtherEntity";
var nEntity = new NEntity
{
Name = nEntityName,
ObjectState = EObjectState.Added
};
var firstOtherEntity = new OtherEntity
{
Name = firstOtherEntityName,
ObjectState = EObjectState.Added
};
var secondOtherEntity = new OtherEntity
{
Name = secondOtherEntityName,
ObjectState = EObjectState.Added
};
nEntity.OtherEntities.Add(firstOtherEntity);
nEntity.OtherEntities.Add(secondOtherEntity);
using (IDataAccessor dataAccessor = new DataAccessor(_dbContextFactory))
{
dataAccessor.InsertOrUpdate(nEntity);
Assert.IsTrue(dataAccessor.HasPendingChanges, "HasPendingChanges should be true!");
await dataAccessor.SaveChangesAsync();
Assert.IsFalse(dataAccessor.HasPendingChanges, "HasPendingChanges should be false directly after Saving!");
}
using (IDataAccessor dataAccessor = new DataAccessor(_dbContextFactory))
{
Assert.IsTrue(await dataAccessor.Set<NEntity>().AnyAsync(nE => nE.Name.Equals(nEntityName)));
var loadedNEntity = await dataAccessor.GetSingleAsync<NEntity>(nE => nE.Name.Equals(nEntityName), entity => entity.OtherEntities);
Assert.AreEqual(2, loadedNEntity.OtherEntities.Count);
Assert.IsTrue(loadedNEntity.OtherEntities.Any(oE => oE.Name.Equals(firstOtherEntityName)));
Assert.IsTrue(loadedNEntity.OtherEntities.Any(oE => oE.Name.Equals(secondOtherEntityName)));
}
}
public static async Task<NEntity> CreateNEntityWithSomeOtherEntities()
{
var nEntity = new NEntity
{
Name = "NEntityWithOtherEntity",
ObjectState = EObjectState.Added
};
var firstOtherEntity = new OtherEntity
{
Name = "FirstOtherEntity",
ObjectState = EObjectState.Added
};
var secondOtherEntity = new OtherEntity
{
Name = "SecondOtherEntity",
ObjectState = EObjectState.Added
};
nEntity.OtherEntities.Add(firstOtherEntity);
nEntity.OtherEntities.Add(secondOtherEntity);
using (IDataAccessor dataAccessor = new DataAccessor(DbContextFactory))
{
dataAccessor.InsertOrUpdate(nEntity);
await dataAccessor.SaveChangesAsync();
}
return nEntity;
}
