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; }