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