/// <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); }