Getting table name within mstest unit test with data from Microsoft Test Manager

Question

I have test methods decorated with a DataSource attribute like:

[DataSource(PROVIDER_INVARIANT_NAME, CONNECTION_STRING, 
"Test Case#", DataAccessMethod.Sequential), 
TestMethod]

with the test case number in MTM replacing "Test Case#". I'm trying to get that number within the unit test but TestContext.DataRow.Table.TableName is always "Table1". Can anyone tell me how to get the real value?

chaliasos · Accepted Answer · 2012-03-19 14:46:54Z

1

Unless I'm wrong, the "TestCase#" cannot be replaced by MTM, so propably you have manually added it in all your DataSource attributes.

This value is constant. Why don't you add a constant variable to your TestClass and then use it on both the DataSourceAttribute and your TestMethod?

EDIT
You can also access the DataSourceAttribute directly:

[TestClass]
public class TestClass
{
    public DataSourceAttribute DataSource
    {
        get
        {
            return (DataSourceAttribute)Attribute.GetCustomAttribute(typeof(TestClass).
                GetMethod("TestMethod"), typeof(DataSourceAttribute));
        }
    }

    [DataSource(PROVIDER_INVARIANT_NAME, CONNECTION_STRING, 
        "Test Case#", DataAccessMethod.Sequential), TestMethod]
    public void TestMethod()
    {
        string TestCaseId = DataSource.TableName;
    }
}

edited Mar 19, 2012 at 14:46

answered Mar 11, 2012 at 13:11

chaliasos

9,8137 gold badges54 silver badges90 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

NickL Over a year ago

Yes I've manually added it. I am having to do it that way at the moment, but I'd much prefer to declare it once in the datasource and then have it accessible in the TestContext. Am I right in thinking that TestContext.DataRow.Table.TableName should be populated?

chaliasos Over a year ago

Yes, I also tried it and the TableName was always "Table1". Check my edited answer if this will help you. However, I still believe that it's more easy if you use a constant variable.

Collectives™ on Stack Overflow

Getting table name within mstest unit test with data from Microsoft Test Manager

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related