/// <summary>
/// Gets the data set.
/// </summary>
/// <typeparam name="T"></typeparam>
/// <returns></returns>
public T GetDataSet <T>() where T : DataSet, new()
{
T result = DataService.GetDataSet <T>(Command);
OutputValues = Command.OutputValues;
return(result);
}
/// <summary>
/// Executes an SP using the specified provider
/// </summary>
/// <param name="spAndParams">The SP name and each argument required - these must be in order</param>
/// <param name="providerName">Specifies the specific provider to use.</param>
/// <returns>System.Data.DataSet</returns>
public static DataSet GetDataSet(string spAndParams, string providerName)
{
QueryCommand cmd = new QueryCommand("EXEC " + spAndParams, providerName);
cmd.CommandType = CommandType.Text;
cmd.ProviderName = providerName;
return(DataService.GetDataSet(cmd));
}
/// <summary>
/// Executes an SP using the specified provider
/// </summary>
/// <param name="spAndParams">The SP name and each argument required - these must be in order</param>
/// <param name="providerName">Specifies the specific provider to use.</param>
/// <returns>System.Data.DataSet</returns>
public static DataSet GetDataSet(string spAndParams, string providerName)
{
QueryCommand cmd = new QueryCommand(String.Concat("EXEC ", spAndParams), providerName)
{
CommandType = CommandType.Text,
ProviderName = providerName
};
return(DataService.GetDataSet(cmd));
}
