SqlBulkCopy InvalidCastException

```csharp
/// <summary>
/// 批量新增数据
/// </summary>
/// <param name="dt"></param>
/// <param name="dbContext"></param>
public void BulkAdd(DataTable dt, IDbContext dbContext)
{
    // 获取 fluent data 框架下的连接对象
    if (dbContext != null && dbContext.Data != null && (dbContext.Data.Connection is SqlConnection) && (dbContext.Data.Transaction is SqlTransaction))
    {
        SqlConnection conn = (SqlConnection)dbContext.Data.Connection;
        if (conn.State != ConnectionState.Open)
        {
            conn.Open();
        }
        SqlTransaction trsaction = (SqlTransaction)dbContext.Data.Transaction;
        SqlBulkCopy sqlbulkcopy = new SqlBulkCopy(conn, SqlBulkCopyOptions.Default, trsaction);
        sqlbulkcopy.DestinationTableName = dt.TableName;
        sqlbulkcopy.WriteToServer(dt);
    }
}
```

### 修改后代码

### 参考文档

1. [SqlBulkCopy - The given ColumnMapping does not match up with any column in the source or destination.](https://sqlbulkcopy-tutorial.net/columnmapping-does-not-match)
1. [单个批量复制操作](https://docs.microsoft.com/zh-cn/dotnet/framework/data/adonet/sql/single-bulk-copy-operations)
1. [SqlBulkCopy.ColumnMappings Property](https://docs.microsoft.com/en-us/dotnet/api/system.data.sqlclient.sqlbulkcopy.columnmappings?view=netframework-4.8)

SqlBulkCopy InvalidCastException

目录

回复内容 *