private Provider InsertTestProvider(SQLiteConnection conn, int i)
 {
     ProviderDAO providerDAO = new ProviderDAO();
     string name = GetRandomName() + i;
     Provider p = new Provider() { ProviderName = name };
     providerDAO.Create(p, conn);
     p.ProviderId = providerDAO.Read("SELECT * FROM providers WHERE provider_id = (SELECT max(provider_id) FROM providers)", conn)[0].ProviderId;
     return p;
 }
 private Provider InsertTestProvider(SQLiteConnection conn)
 {
     ProviderDAO providerDAO = new ProviderDAO();
     Provider p = new Provider() { ProviderName = "HuntTestProvider" };
     providerDAO.Create(p, conn);
     p.ProviderId = providerDAO.Read("SELECT * FROM providers WHERE provider_name = 'HuntTestProvider'", conn)[0].ProviderId;
     return p;
 }