public static IEnumerable <Layout> GetLayouts()
            {
                var repository = new LayoutReadRepository(new DataContext(new PersistenceConfiguration(RepositoryTestsHelper.ConnectionString)));
                var result     = repository.ListAsync(null, null, null).Result;

                return(result);
            }
            public static Layout CreateLayout(Guid id, string name)
            {
                // prepare
                var writeRepository = new LayoutWriteRepository(new DataContext(new PersistenceConfiguration(RepositoryTestsHelper.ConnectionString)));
                var readRepository  = new LayoutReadRepository(new DataContext(new PersistenceConfiguration(RepositoryTestsHelper.ConnectionString)));

                // create
                var layout = new Layout(id, name);

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

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

                return(result);
            }