public void DeleteFact() { var connection = default(DbConnection); var transaction = default(DbTransaction); try { connection = this._factory.CreateConnection(); connection.Open(); transaction = connection.BeginTransaction(IsolationLevel.Serializable); var repository = new MembershipUsersRepository(); long membershipId = long.MaxValue; long userId = long.MaxValue; if (!repository.Create(new MembershipUserEntity() { MembershipID = membershipId, UserID = userId, }, connection, transaction)) { Assert.True(false); } Assert.True(repository.Delete(new MembershipUsersCriteria() { MembershipID = membershipId, }, connection, transaction)); //Assert.True(repository.Delete(new MembershipUserEntity() { MembershipID = membershipId, UserID = userId, }, connection, transaction)); } finally { if (transaction != null) { transaction.Rollback(); } if (connection != null) { connection.Close(); } } }
public void DeleteForeighKeyOnMembershipIDFact() { var connection = default(DbConnection); var transaction = default(DbTransaction); try { connection = this._factory.CreateConnection(); connection.Open(); transaction = connection.BeginTransaction(); // Memberships var membership = new MembershipEntity() { Name = new Random().Next().ToString(CultureInfo.InvariantCulture), Password = @"password", }; var memberships = new MembershipsRepository(); membership.CreatedOn = KandaRepository.GetUtcDateTime(connection, transaction); var status = MembershipCreateStatus.ProviderError; if (!memberships.Create(membership , connection, transaction, out status)) { Assert.True(!true); } // Users var user = new UserEntity() { /*ID = @"",*/ FamilyName = @"family name", GivenName = @"given name", AdditionalName = @"additional name", Description = @"description", CreatedOn = membership.CreatedOn, Enabled = true, }; var users = new UsersRepository(); if (!users.Create(user, connection, transaction)) { Assert.True(!true); } // MembershipUsers var entity = new MembershipUserEntity() { MembershipID = membership.ID, UserID = user.ID }; var repository = new MembershipUsersRepository(); if (!repository.Create(entity, connection, transaction)) { Assert.True(!true); } // 削除 if (!repository.Delete(new MembershipUsersCriteria() { MembershipID = entity.MembershipID, UserID = entity.UserID, }, connection, transaction)) { Assert.True(!true); } if (!memberships.Delete(entity.MembershipID, connection, transaction)) { Assert.True(!true); } if (!users.Delete(entity.UserID, connection, transaction)) { Assert.True(!true); } Assert.True(true); } finally { if (transaction != null) { transaction.Rollback(); } if (connection != null) { connection.Close(); } } }