文档
文档传送门:https://docs.microsoft.com/en-us/visualstudio/test/how-to-create-a-data-driven-unit-test?view=vs-2019
正文
- 连接VS自带数据库,连接字符串的查看方式:
(视图-SQL Server对象浏览器)
- DataSource属性的设置方法:
[DataSource("System.Data.SqlClient",
@"Data Source=(localdb)\ProjectsV13;Initial Catalog=Test;Integrated Security=True;Connect Timeout=30;Encrypt=False;TrustServerCertificate=False;ApplicationIntent=ReadWrite;MultiSubnetFailover=False","Table",DataAccessMethod.Sequential)]
[TestMethod()]
public void AddIntegers_DataSourceTest()
{
var account = new CheckingAccount();
int x = Convert.ToInt32(TestContext.DataRow["x"]);
int y = Convert.ToInt32(TestContext.DataRow["y"]);
int expected = Convert.ToInt32(TestContext.DataRow["result"]);
Assert.AreEqual(expected, account.AddIntegers(x, y));
}
可能会提示报错“An object reference is required for the nonstatic field, method, or property ‘member’”,引用对象非静态自字段、方法或属性:
需要在测试类内先声明属性TestContext:
public TestContext TestContext { get; set; }
运行测试: