private static BuildInstance GetAddBuildInstance(PEUTEST002Entities dbc, int buildDefnId, string buildInstanceName, string dateStr)
        {
            var countBuildInstances = (from x in DatabaseInstance.BuildInstances
                                       where x.BuildDefinitionId == buildDefnId && x.BuildInstanceName == buildInstanceName
                                       select x).Count();

            if (countBuildInstances <= 0)
            {
                dbc.BuildInstances.Add(new BuildInstance
                {
                    BuildDefinitionId = buildDefnId,
                    BuildInstanceName = buildInstanceName,
                    DateId            = dateStr
                });
                dbc.SaveChanges();

                BuildInstance bi = (from x in dbc.BuildInstances
                                    where x.BuildDefinitionId == buildDefnId && x.BuildInstanceName == buildInstanceName
                                    select x).ToList()[0];
                Console.WriteLine($"Added Build Instance {bi.BuildDefinition.BuildDefinitionName} / {buildInstanceName}");
                DatabaseInstance.BuildInstances.Add(bi);
            }
            return((from x in DatabaseInstance.BuildInstances
                    where x.BuildDefinitionId == buildDefnId && x.BuildInstanceName == buildInstanceName
                    select x).ToList()[0]);
        }
        private static TestDate GetAddTestDate(PEUTEST002Entities dbc, string TestDateStr)
        {
            var count = (from u in DatabaseInstance.TestDates
                         where u.DateId == TestDateStr
                         select u).Count();

            if (count <= 0)
            {
                dbc.TestDates.Add(new TestDate {
                    DateId = TestDateStr
                });
                dbc.SaveChanges();
                TestDate td = (from u in dbc.TestDates
                               where u.DateId == TestDateStr
                               select u).ToList()[0];
                DatabaseInstance.TestDates.Add(td);
            }
            return((from u in DatabaseInstance.TestDates
                    where u.DateId == TestDateStr
                    select u).ToList()[0]);
        }