public void GetFact()
{
var connection = default(DbConnection);
var transaction = default(DbTransaction);
try
{
connection = this._factory.CreateConnection();
connection.Open();
transaction = connection.BeginTransaction(IsolationLevel.Serializable);
var repository = new MembershipUsersRepository();
var membershipId = long.MaxValue;
var userId = long.MaxValue;
if (!repository.Create(new MembershipUserEntity() { MembershipID = membershipId, UserID = userId, }, connection, transaction)) { Assert.True(false); }
else
{
/*
var gotten = repository.Get(new MembershipUsersCriteria() { MembershipID = membershipId, }, connection, transaction);
foreach (var entity in gotten)
{
var user = new User(new UserEntity() { ID = entity.UserID, });
var found = default(UserEntity);
user.Find(out found);
Assert.True(0 < found.ID);
}
*/
}
}
finally
{
if (transaction != null) { transaction.Rollback(); }
if (connection != null) { connection.Close(); }
}
}
public void CreateFact()
{
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;
Assert.True(repository.Create(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(); }
}
}
public void TrucnateFact()
{
var connection = default(DbConnection);
var transaction = default(DbTransaction);
try
{
connection = this._factory.CreateConnection();
connection.Open();
transaction = connection.BeginTransaction(IsolationLevel.Serializable);
var repository = new MembershipUsersRepository();
Assert.True(repository.Truncate(connection, transaction));
}
finally
{
if (transaction != null) { transaction.Rollback(); }
if (connection != null) { connection.Close(); }
}
}
