/// <summary>
/// Add a Table-Valued Parameter (SQL Server 2008+) with a DbDataReader value
/// </summary>
/// <param name="parameterName">The name of the parameter</param>
/// <param name="dataReader">An object derived from DbDataReader to stream rows of data to the table-valued parameter</param>
/// <returns>A SqlParameter object</returns>
public SqlParameter AddTableValue(string parameterName, DbDataReader dataReader)
{
SqlParameter sqlParameter = AddTableValue(parameterName);
sqlParameter.Value = dataReader.AsParameterValue();
return(sqlParameter);
}
/// <summary>
/// Set Value of Table-Valued Parameter (SQL Server 2008+)
/// </summary>
/// <param name="dbParameter"></param>
/// <param name="readerValue"></param>
/// <returns></returns>
public static DbParameter SetValue(this DbParameter dbParameter, DbDataReader readerValue)
{
dbParameter.Value = readerValue.AsParameterValue();
return(dbParameter);
}
