使用C#将XML文件加载到SQL Server表中

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

class Program
{
    static void Main()
    {
        // 创建连接字符串
        string connectionString = "Data Source=ServerName;Initial Catalog=DatabaseName;User ID=UserName;Password=Password";

        // 创建SqlConnection对象
        using (SqlConnection connection = new SqlConnection(connectionString))
        {
            // 打开数据库连接
            connection.Open();

            // 加载XML文件
            XmlDocument xmlDocument = new XmlDocument();
            xmlDocument.Load("path/to/xml/file.xml");

            // 获取XML文件中的数据
            XmlNodeList nodes = xmlDocument.SelectNodes("/Root/Node");

            // 遍历XML节点并插入到SQL Server表中
            foreach (XmlNode node in nodes)
            {
                string value1 = node.SelectSingleNode("Value1").InnerText;
                string value2 = node.SelectSingleNode("Value2").InnerText;

                // 创建SQL插入语句
                string insertQuery = $"INSERT INTO TableName (Column1, Column2) VALUES ('{value1}', '{value2}')";

                // 创建SqlCommand对象并执行SQL语句
                using (SqlCommand command = new SqlCommand(insertQuery, connection))
                {
                    command.ExecuteNonQuery();
                }
            }

            // 关闭数据库连接
            connection.Close();
        }
    }
}