public static XElement GetOutput(this SqlParameterCollection parameters)
{
var output = new XElement("content");
foreach (SqlParameter p in parameters)
{
if (
p.Direction == ParameterDirection.Input ||
p.Value == null || p.Value == DBNull.Value)
{
continue;
}
var xp = new XElement("parameter");
output.Add(xp);
xp.Add(new XAttribute("name", p.ParameterName.Replace("@", "")));
DBTypeConverter.ParamToXElenemt(p, xp);
}
return(output);
}
