使用C#从XML创建SQL表

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

class Program
{
    static void Main()
    {
        string xmlFilePath = "path/to/xml/file.xml";
        string connectionString = "your_connection_string";

        // 加载XML文件
        XmlDocument xmlDoc = new XmlDocument();
        xmlDoc.Load(xmlFilePath);

        // 提取表名称和字段信息
        XmlNodeList tableNodes = xmlDoc.SelectNodes("/tables/table");
        foreach (XmlNode tableNode in tableNodes)
        {
            string tableName = tableNode.Attributes["name"].Value;
            Console.WriteLine("Creating table: " + tableName);

            // 构建CREATE TABLE语句
            string createTableQuery = "CREATE TABLE " + tableName + " (";

            XmlNodeList columnNodes = tableNode.SelectNodes("column");
            foreach (XmlNode columnNode in columnNodes)
            {
                string columnName = columnNode.Attributes["name"].Value;
                string dataType = columnNode.Attributes["type"].Value;
                createTableQuery += columnName + " " + dataType + ",";
            }

            createTableQuery = createTableQuery.TrimEnd(',') + ")";

            // 执行SQL语句创建表
            using (SqlConnection connection = new SqlConnection(connectionString))
            {
                SqlCommand command = new SqlCommand(createTableQuery, connection);
                connection.Open();
                command.ExecuteNonQuery();
                Console.WriteLine("Table created.");
            }
        }
    }
}