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; }