public void sample_test_stored_procedure() { using (var db = new ADODatabaseContext("", "sampledata")) { db.ExecuteNonQuery("INSERT INTO department (Name) VALUES ('sales')"); db.ExecuteNonQuery("INSERT INTO person (First, Last, Department) VALUES ('Joe', 'Cool', 1)"); DataSet data = db.StoredProcedureSelect("ExampleStoredProcedure"); Assert.AreEqual(1, data.Tables[0].Rows.Count); } }
public void TestMethod1() { // moved this to here so the fake stored procedures don't break this unit test ReadPersonNames.Instance.CreateStoredProcedure(UnitTestHelpers.InstanceName); using (var db = new ADODatabaseContext("TEST", "sampledata")) { db.ExecuteNonQuery("INSERT INTO person (first,last) VALUES ('Mary','Jane')"); db.ExecuteNonQuery("INSERT INTO person (first,last) VALUES ('Joe','Cool')"); } var personSelector = new PersonSelector(); DataSet data = personSelector.ReadNames(); Assert.AreEqual(2, data.Tables[0].Rows.Count); }