public void ConnectionTest()
 {
     using (TravelTimeDBContext context = new TravelTimeDBContext(new DbContextOptionsBuilder <TravelTimeDBContext>().UseNpgsql(this.connectionstring).Options))
     {
         try
         {
             if (!(context.GetService <IDatabaseCreator>() as RelationalDatabaseCreator).Exists())
             {
                 throw new Exception("db does ont exist");
             }
         }
         catch (Exception ex)
         {
             Assert.IsTrue(false, ex.Message);
         }
     }
 }
 public void QueryTest()
 {
     using (TravelTimeDBContext context = new TravelTimeDBContext(new DbContextOptionsBuilder <TravelTimeDBContext>().UseNpgsql(this.connectionstring).Options))
     {
         try
         {
             var testQuery = context.TravelTime.ToList();
             Assert.IsNotNull(testQuery, testQuery.Count.ToString());
         }
         catch (Exception ex)
         {
             Assert.IsTrue(false, ex.Message);
         }
         finally
         {
         }
     }
 }