MS UNIT Test Data Driven with CSV file

 MS UNIT Test Data Driven with CSV file

[TestClass]
    public class UnitTestCalculateMath
    {
        public TestContext TestContext { get; set; }

        [DataSource("Microsoft.VisualStudio.TestTools.DataSource.CSV", @"E:\TrainingSamples\CalculateMaths\UnitTestCalculateMath\data.csv", "data#csv", DataAccessMethod.Sequential), DeploymentItem("data.csv"), TestMethod]
        public void TestExcel()
        {
            int x = Convert.ToInt16(TestContext.DataRow["Num1"].ToString());
            int y = Convert.ToInt16(TestContext.DataRow["Num2"].ToString());
            int expected = Convert.ToInt16(TestContext.DataRow["result"].ToString());

            CalculateMaths.MathClass obj = new CalculateMaths.MathClass();

            int actual = obj.Add(x, y);

            Assert.AreEqual(expected, actual);
        }
    }