// build the executable SQL code
private new void Build()
{
// try throw the exception of the execution phase.
TryThrow();
Executable.ArgumentsCriticalCheck(true);
TryThrow();
var buildArgs = new BuildArgs(null);
buildArgs.TestBody = _testBody;
// executable is build by the context of its compilable object
var execSql = Executable.Build(
new BuildContext(Executable.Compilable), buildArgs);
_sql = BuildOutputWrapper(execSql);
}
private string BuildExecProc(BuildContext buildContext, BuildArgs buildArgs)
{
// assign the current node of the build context
buildContext.Current = _innerObject;
if (ReturnVariable != null)
{
return(Text.GenerateSql(1000)
.Append(Executable.Build(buildContext, buildArgs))
.NewLine(Text.Set).S()
.Append(ReturnVariable).Append(Text._Equal_).Append(Text.Reserved.ReturnValueOuterParam)
.Terminate()
.ToString());
}
else
{
return(Executable.Build(buildContext, buildArgs));
}
}