如何使用C#控制台应用程序中的XmlTextReader将XML数据插入到SQL Server表中？

using System;
using System.Data.SqlClient;
using System.Xml;

namespace ConsoleApp
{
    class Program
    {
        static void Main(string[] args)
        {
            // 连接到SQL Server数据库
            string connectionString = "Data Source=(local);Initial Catalog=YourDatabase;Integrated Security=True";
            using (SqlConnection connection = new SqlConnection(connectionString))
            {
                connection.Open();

                // 创建XmlTextReader对象并读取XML数据
                using (XmlTextReader reader = new XmlTextReader("data.xml"))
                {
                    while (reader.Read())
                    {
                        // 判断当前行的节点类型
                        if (reader.NodeType == XmlNodeType.Element && reader.Name == "record")
                        {
                            // 解析XML数据
                            string name = reader.GetAttribute("name");
                            string age = reader.GetAttribute("age");

                            // 将数据插入到SQL Server表中
                            string insertQuery = $"INSERT INTO YourTable (Name, Age) VALUES ('{name}', '{age}')";
                            using (SqlCommand command = new SqlCommand(insertQuery, connection))
                            {
                                command.ExecuteNonQuery();
                            }
                        }
                    }
                }
            }
        }
    }
}