public static IEnumerable <OperationalDepartment> GetOperationalDepartments()
            {
                var repository = new OperationalDepartmentReadRepository(new DataContext(new PersistenceConfiguration(RepositoryTestsHelper.ConnectionString)));
                var result     = repository.ListAsync(null, null, null).Result;

                return(result);
            }
            public static OperationalDepartment CreateOperationalDepartment(Guid id, string code, string name, string site, string source)
            {
                // prepare
                var writeRepository = new OperationalDepartmentWriteRepository(new DataContext(new PersistenceConfiguration(RepositoryTestsHelper.ConnectionString)));
                var readRepository  = new OperationalDepartmentReadRepository(new DataContext(new PersistenceConfiguration(RepositoryTestsHelper.ConnectionString)));

                // create
                var operationalDepartment = new OperationalDepartment(id, code, name, site, source);
                IEnumerable <OperationalDepartment> operationalDepartments = new List <OperationalDepartment>()
                {
                    operationalDepartment
                };

                foreach (var item in operationalDepartments)
                {
                    writeRepository.CreateAsync(item).GetAwaiter().GetResult();
                }

                // result
                var result = readRepository.GetAsync(operationalDepartment.Id).Result;

                return(result);
            }