private static void InsertSolution(string connectionString, string solutionId, IEnumerable <Capability> capabilities, Faker faker)
        {
            var solutionCaps = faker.Random.Int(8, 17);
            var solCaps      = GetRandomCaps(capabilities, solutionCaps);

            var solution       = GenerateSolution.NewSolution(faker, solutionId);
            var solutionDetail = GenerateSolution.NewSolutionDetail(faker, solutionId);

            GenerateSolution.InsertSolution(connectionString, solution);
            GenerateSolution.InsetSolutionDetail(connectionString, solutionDetail);
            GenerateSolution.Update(connectionString, solutionId, solutionDetail.SolutionDetailId);

            GenerateCapabilities.InsertSolutionCapabilities(connectionString, solCaps, solutionId);
            GenerateCapabilities.InsertSolutionEpics(connectionString, solCaps, solutionId);

            var contact = GenerateContacts.NewContactDetail(solutionId);

            GenerateContacts.InsertContact(connectionString, contact);
        }