public static IEnumerable <Icon> GetIcons()
            {
                var repository = new IconReadRepository(new DataContext(new PersistenceConfiguration(RepositoryTestsHelper.ConnectionString)));
                var result     = repository.ListAsync(null, null, null).Result;

                return(result);
            }
            public static Icon CreateIcon(Guid id, string name, string dataPath)
            {
                // prepare
                var writeRepository = new IconWriteRepository(new DataContext(new PersistenceConfiguration(RepositoryTestsHelper.ConnectionString)));
                var readRepository  = new IconReadRepository(new DataContext(new PersistenceConfiguration(RepositoryTestsHelper.ConnectionString)));

                // create
                var icon = new Icon(id, name, dataPath);

                writeRepository.CreateAsync(icon).GetAwaiter().GetResult();

                // result
                var result = readRepository.GetAsync(id).Result;

                return(result);
            }