public static IEnumerable <Input> GetInputs()
            {
                var repository = new InputReadRepository(new DataContext(new PersistenceConfiguration(RepositoryTestsHelper.ConnectionString)));
                var result     = repository.ListAsync(null, null, null).Result;

                return(result);
            }
            public static Input CreateInput(Guid id, string name, string description, Guid icon, string instruction)
            {
                // prepare
                var writeRepository = new InputWriteRepository(new DataContext(new PersistenceConfiguration(RepositoryTestsHelper.ConnectionString)));
                var readRepository  = new InputReadRepository(new DataContext(new PersistenceConfiguration(RepositoryTestsHelper.ConnectionString)));

                // create
                var input = new Input(id, name, description, icon, instruction);

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

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

                return(result);
            }