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