我正在使用SQLBulkCopy在我的表中加載數據。它工作正常,但有時數據不會加載到我的表中,我沒有收到任何錯誤。
那是我的代碼:
Dim dtbTabelaLoad As New DataTable("base_fat_contrato_linha_composicao")
dtbTabelaLoad.Columns.Add("fk_id_contrato")
dtbTabelaLoad.Columns.Add("access_nbr")
dtbTabelaLoad.Columns.Add("fk_id_composicao")
For Each linha As Linha In objLinhaFinal
Dim strContrato As String = linha.ComposicaoLinha.NumeroContrato
Dim strComposicao As String = linha.ComposicaoLinha.NumeroComposicao
Dim strNumeroLinha As String = linha.NumeroLinha
dtbTabelaLoad.Rows.Add(strContrato, strNumeroLinha, strComposicao)
Next
Dim load As SqlBulkCopy = New SqlBulkCopy(strStringConexao, SqlBulkCopyOptions.Default)
load.DestinationTableName = "base_fat_contrato_linha_composicao"
load.ColumnMappings.Add("fk_id_contrato", "fk_id_contrato")
load.ColumnMappings.Add("access_nbr", "access_nbr")
load.ColumnMappings.Add("fk_id_composicao", "fk_id_composicao")
load.WriteToServer(dtbTabelaLoad)
load.Close()
我在我的程序中多次運行此代碼,但有時數據不會出現在表中。