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