MS Test Project

Associating the DB Data with a Test

enum Column

      {

         UserId,

         Password,

         IsValid

      }



      private TestContext testContextInstance;



      /// <summary>

      ///Gets or sets the test context which provides

      ///information about and functionality for the 

      ///current test run.

      ///</summary>

      public TestContext TestContext

      {

         get

         {

            return testContextInstance;

         }

         set

         {

            testContextInstance = value;

         }

      }



      [TestMethod]

      [Owner("Mark Michaelis")]

      [TestProperty("TestCategory", "Developer"), 

      DataSource("System.Data.SqlClient", 

         "Data Source=.//SQLEXPRESS;AttachDbFilename=/"<Path to the sample .mdf file
>";Integrated Security=True", 

         "LogonInfoTest", 

         DataAccessMethod.Sequential)]



      public void ChangePasswordTest()

      {

         

         string userId = 

            (string)TestContext.DataRow[(int)Column.UserId];

         string password = 

            (string)TestContext.DataRow[(int)Column.Password];

         bool isValid = 

            (bool)TestContext.DataRow[(int)Column.IsValid];



         LogonInfo logonInfo = new LogonInfo(userId, "P@ssw0rd");



         if (!isValid)

         {

            Exception exception = null;

            try

            {

               logonInfo.ChangePassword(

                  "P@ssw0rd", password);

            }

            catch (Exception tempException)

            {

               exception = tempException;

            }

            Assert.IsNotNull(exception,

               "The expected exception was not thrown.");

            Assert.AreEqual<Type>(

               typeof(ArgumentException), exception.GetType(),

               "The exception type was unexpected.");

         }

         else

         {

            logonInfo.ChangePassword(

               "P@ssw0rd", password);

            Assert.AreEqual<string>(password, logonInfo.Password,

               "The password was not changed.");

         }

      }