using (var ctx = new AssistantContext())
            {
                PackagedSolution.Appliances = new ApplianceList(AppliancesInPackagedSolution.ToList());

                // Attach appliances to this DataContext (otherwise they will be duplicated)
                foreach (var appliance in PackagedSolution.Appliances)
                    ctx.Appliances.Attach(appliance);

                if (PackagedSolution.CreationDate == default(DateTime))
                    PackagedSolution.CreationDate = DateTime.Now;

                ctx.PackagedSolutions.AddOrUpdate(x => x.Id, PackagedSolution);
                ctx.SaveChanges();

                if (PackagedSolution.Id == 0)
                {
                    ctx.Entry(PackagedSolution).GetDatabaseValues();
                }
                Console.WriteLine(PackagedSolution.Id);
            }