public static string GetInfo(DbParameterCollection parCollection)
{
var parameters = from p in parCollection.OfType <DbParameter>()
select $"ParamterInfo: Name= { p.ParameterName}, DbType= {p.DbType}, Size= { p.Size}";
StringBuilder builder = new StringBuilder();
builder.AppendLine("DbParameterCollection Info:");
builder.AppendLine("------------------------------------------");
builder.AppendLine(string.Join(NewLine, parameters));
builder.AppendLine("------------------------------------------");
return(builder.ToString());
}
public static IList <DbParameter> SortByParameterName(this DbParameterCollection parameters)
{
return(parameters.OfType <DbParameter>().OrderBy(x => x.ParameterName).ToList());
}
