/// <summary>
/// Executes an SQL query and reads the results into a data grid
/// </summary>
/// <param name="context">The template context</param>
/// <param name="parameterValues">The parameter values</param>
/// <returns>The data grid</returns>
protected override object GenerateOutput
(
TemplateContext context,
params object[] parameterValues
)
{
Validate.IsNotNull(context);
var connectionName = GetParameterValue <string>
(
"ConnectionName",
parameterValues
);
var sql = GetParameterValue <string>
(
"SQL",
parameterValues
);
var connection = _connectionRepository.GetConnection
(
connectionName
);
var grid = connection.Adapter.ExecuteQuery
(
connection.ConnectionString,
sql
);
return(grid);
}
/// <summary>
/// Executes a stored procedure and reads the results into a data grid
/// </summary>
/// <param name="context">The template context</param>
/// <param name="parameterValues">The parameter values</param>
/// <returns>The data grid</returns>
protected override object GenerateOutput
(
TemplateContext context,
params object[] parameterValues
)
{
Validate.IsNotNull(context);
var connectionName = GetParameterValue <string>
(
"ConnectionName",
parameterValues
);
var procedureName = GetParameterValue <string>
(
"ProcedureName",
parameterValues
);
var procedureParameters = ExtractKeyValuePairs <string, object>
(
parameterValues,
2
);
var connection = _connectionRepository.GetConnection
(
connectionName
);
var grid = connection.Adapter.ExecuteStoredProcedure
(
connection.ConnectionString,
procedureName,
procedureParameters
);
return(grid);
}
