public static SqlScriptAction AddParameter <TParameter>(this SqlScriptAction scriptAction, Action <TParameter> action) where TParameter : SqlScriptParameter
{
var parameter = Activator.CreateInstance <TParameter>();
parameter.SqlScriptAction = scriptAction;
scriptAction.Parameters.Add(parameter);
action(parameter);
return(scriptAction);
}
public void SqlTest1()
{
var test = new Test();
var sql = this.GetType().Assembly.GetResourceAsText("XmlFiles.InsertTouAndCosts.sql");
var action = new SqlScriptAction {
Name = "pretest", SqlScript = sql
};
var touid = new OutputParameter {
DbType = DbType.Int32, Name = "@touid"
};
var costid = new OutputParameter {
DbType = DbType.Int32, Name = "@costid"
};
var dt = new InputParameter {
DbType = DbType.DateTime, Name = "@dt", Value = new DateTime(2001, 06, 20)
};
action.Parameters.Add(touid);
action.Parameters.Add(costid);
action.Parameters.Add(dt);
action.ConnectionContext = Setup.Default.Connections["ExampleDb-Test"];
test.Actions.Add(action);
sql = this.GetType().Assembly.GetResourceAsText("XmlFiles.ExecP_AvgCost_Monthly.sql");
action = new SqlScriptAction {
Name = "test", SqlScript = sql
};
action.ConnectionContext = Setup.Default.Connections["ExampleDb-Test"];
action.Parameters.Add(new LinkedInputParameter {
LinkedParameter = touid
});
action.Parameters.Add(new LinkedInputParameter {
LinkedParameter = costid
});
test.Actions.Add(action);
var testResults = test.Execute();
var expectedResult = ActionResult.ReadFromResource(Assembly.GetExecutingAssembly(), "XmlFiles.TimeSerieResult.xml");
if (!testResults["test"].EqualsActionResult(expectedResult))
{
var dbResult = testResults["test"].Serialize();
Assert.AreEqual(expectedResult.Serialize(), dbResult);
}
}
public static SqlScriptAction WithSqlFromResource(this SqlScriptAction scriptAction, Assembly assembly, string resourceName)
{
scriptAction.SqlScript = Resources.GetResourceAsText(assembly, resourceName);
return(scriptAction);
}
public static SqlScriptAction WithSqlFromResource(this SqlScriptAction scriptAction, string resourceName)
{
return(scriptAction.WithSqlFromResource(Assembly.GetCallingAssembly(), resourceName));
}
public static SqlScriptAction WithSql(this SqlScriptAction scriptAction, string sql)
{
scriptAction.SqlScript = sql;
return(scriptAction);
}
