var xdoc = XElement.Load(原始XML文件路径);
var attr = xdoc.Element("root").Attribute("attr1").value;
using(var cn = new SqlConnection())
using(var cmd = new SqlCommand())
{
cmd.CommandText = "Select * from your table WHERE field ='" + attr + "'";
var reader = cmd.ExecuteReader();
}