/// <summary>
/// Fetch Output Parameter values include input values
/// </summary>
/// <param name="collection"></param>
/// <param name="parameterPrefixText"></param>
protected virtual void GetOutputParamterValuesIncludeInput(DbParameterCollection collection, string parameterPrefixText)
{
Parameters.Clear();
foreach (DbParameter param in collection)
{
if (param.Direction == ParameterDirection.Output || param.Direction == ParameterDirection.InputOutput)
{
Parameters.AddWithValue(param.ParameterName.Substring(parameterPrefixText.Length), param.Value);
}
}
}
/// <summary>
/// Fetch Output parameter values
/// </summary>
/// <param name="collection">DbParameterCollection</param>
/// <param name="parameterPrefixText">parameter prefix Text</param>
protected void GetOutputParamterValues(DbParameterCollection collection, string parameterPrefixText)
{
var dbparams = from DbParameter d in collection
where d.Direction == ParameterDirection.Output ||
d.Direction == ParameterDirection.InputOutput
select new { ParamName = d.ParameterName, Value = d.Value };
foreach (var param in dbparams)
{
Parameters.AddWithValue(param.ParamName.Substring(parameterPrefixText.Length), param.Value);
}
}
