public void UpdateUserRole()
        {
            IdentityUser user = new IdentityUser {
                UserName = "******", Email = "*****@*****.**", PhoneNumber = "1234567890", PasswordHash = "@#$rfgt$##WE", EmailConfirmed = true, PhoneNumberConfirmed = true, TwoFactorEnabled = false, LockoutEnabled = false, AccessFailedCount = 0
            };

            user = userTable.Insert(user);
            IdentityUser user2 = new IdentityUser {
                UserName = "******", Email = "*****@*****.**", PhoneNumber = "1234567890", PasswordHash = "@#$rfgt$##WE", EmailConfirmed = true, PhoneNumberConfirmed = true, TwoFactorEnabled = false, LockoutEnabled = false, AccessFailedCount = 0
            };

            user2 = userTable.Insert(user2);
            dynamic role = new { Name = "Admin" };

            role = roleTable.Insert(role);
            dynamic userRole = new { UserId = user.Id, RoleId = role.Id };

            userRole        = userRoleTable.Insert(userRole);
            userRole.UserId = user2.Id;
            userRoleTable.Update(userRole);
            int userId = userRoleTable.Single(where : $"RoleId={role.Id}").UserId;

            Assert.AreEqual(user2.Id, userId);
        }