如何使用c# .Net将整个表从ODBC源复制到SQL server，而不指定列？

using System;
using System.Data;
using System.Data.Odbc;
using System.Data.SqlClient;

namespace ODBCtoSQLServer
{
    class Program
    {
        static void Main(string[] args)
        {
            string odbcConnectionString = "yourODBCConnectionString";
            string sqlServerConnectionString = "yourSQLServerConnectionString";
            string tableName = "yourTableName";

            using (OdbcConnection odbcConnection = new OdbcConnection(odbcConnectionString))
            {
                odbcConnection.Open();

                using (SqlCommand sqlCommand = new SqlCommand())
                {
                    using (SqlConnection sqlConnection = new SqlConnection(sqlServerConnectionString))
                    {
                        sqlConnection.Open();

                        // 从ODBC源中获取整个表的数据
                        string selectQuery = $"SELECT * FROM {tableName}";
                        using (OdbcDataAdapter odbcDataAdapter = new OdbcDataAdapter(selectQuery, odbcConnection))
                        {
                            DataTable dataTable = new DataTable();
                            odbcDataAdapter.Fill(dataTable);

                            // 生成INSERT INTO语句的列部分
                            string columns = "";
                            foreach (DataColumn column in dataTable.Columns)
                            {
                                columns += "[" + column.ColumnName + "],";
                            }
                            columns = columns.TrimEnd(',');

                            // 生成INSERT INTO语句的值部分
                            foreach (DataRow row in dataTable.Rows)
                            {
                                string values = "";
                                foreach (var item in row.ItemArray)
                                {
                                    values += "'" + item.ToString() + "',";
                                }
                                values = values.TrimEnd(',');

                                // 执行INSERT INTO语句，将数据插入到SQL Server中
                                string insertQuery = $"INSERT INTO {tableName} ({columns}) VALUES ({values})";
                                sqlCommand.CommandText = insertQuery;
                                sqlCommand.Connection = sqlConnection;
                                sqlCommand.ExecuteNonQuery();
                            }
                        }
                    }
                }
            }

            Console.WriteLine("Data copied from ODBC source to SQL Server successfully.");

            Console.ReadLine();
        }
    }
}