public void testAddProv() { clearDatabase(); conn.Open(); testCom = new MySqlCommand(proManager.AddEntity(testProvEntry), conn); testCom.ExecuteNonQuery(); com.CommandText = "SELECT npi FROM npi_provider_data WHERE npi = 123456"; int result = int.Parse(com.ExecuteScalar().ToString()); conn.Close(); Assert.AreEqual(123456, result, "testing adding provider to an empty db"); }