/// <summary>
/// Executes the stored procedure and returns a <see cref="System.Data.DataSet"/>.
/// </summary>
/// <param name="parameters">A <see cref="System.Object"/> array containing zero of more parameters values</param>
/// <returns><see cref="System.Data.DataSet"/></returns>
public DataSet ExecuteDataSet(params object[] parameters)
{
FillParameters(parameters);
Connection.ExecutionType executionType = mFillSchema ?
Connection.ExecutionType.ExecuteDataSetWithSchema : Connection.ExecutionType.ExecuteDataSet;
return((DataSet)mConnection.ExecuteCommand(executionType, mSqlCommand));
}
/// <summary>
/// Executes the stored procedure and returns a <see cref="System.Data.DataTable"/>.
/// </summary>
/// <example>
/// The following example shows how to execute a stored procedure and populate a <see cref="System.Data.DataTable"/>.
/// <code>
/// <![CDATA[
/// Connection connection = new Connection();
/// DataTable customerDataTable = connection.StoredProcedures["GetCustomerList"].ExecuteDataTable();
/// ]]>
/// </code>
/// </example>
/// <param name="parameters">A <see cref="System.Object"/> array containing zero of more parameters values</param>
/// <returns><see cref="System.Data.DataTable"/></returns>
public DataTable ExecuteDataTable(params object[] parameters)
{
FillParameters(parameters);
Connection.ExecutionType executionType = mFillSchema == true ?
Connection.ExecutionType.ExecuteDataTableWithSchema : Connection.ExecutionType.ExecuteDataTable;
return((DataTable)mConnection.ExecuteCommand(executionType, mSqlCommand));
}
/// <summary>
/// Executes the stored procedure and returns a <see cref="System.Data.DataSet"/>.
/// </summary>
/// <returns><see cref="System.Data.DataSet"/></returns>
public DataSet ExecuteDataSet()
{
Connection.ExecutionType executionType = mFillSchema ?
Connection.ExecutionType.ExecuteDataSetWithSchema : Connection.ExecutionType.ExecuteDataSet;
return((DataSet)mConnection.ExecuteCommand(executionType, mSqlCommand));
}
/// <summary>
/// Executes the stored procedure and returns a <see cref="System.Data.DataTable"/>.
/// </summary>
/// <returns><see cref="System.Data.DataTable"/></returns>
public DataTable ExecuteDataTable()
{
Connection.ExecutionType executionType = mFillSchema == true ?
Connection.ExecutionType.ExecuteDataTableWithSchema : Connection.ExecutionType.ExecuteDataTable;
return((DataTable)mConnection.ExecuteCommand(executionType, mSqlCommand));
}
