public TestCaseSelectedArgs(string storedProcedureName, SqlSync.SprocTest.Configuration.TestCase testCase)
{
this.StoredProcedureName = storedProcedureName;
this.TestCase = testCase;
}
public static string GenerateTestSql(string storedProcedureName, string databaseName, Configuration.TestCase testCase)
{
System.Text.StringBuilder sb = new StringBuilder("exec " + databaseName + "." + storedProcedureName + " ");
if (testCase.Parameter != null)
{
for (int i = 0; i < testCase.Parameter.Length; i++)
{
sb.Append(testCase.Parameter[i].Name + "=");
if (testCase.Parameter[i].Value.ToUpper().Trim() == "NULL")
{
sb.Append("NULL,");
}
else
{
sb.Append("'" + testCase.Parameter[i].Value + "',");
}
}
sb.Length = sb.Length - 1;
}
return(sb.ToString());
}
