InvalidOperationException(SqlException) on SqlBulkCopy

[xinbingyiran]

when I insert some rows into table named "User" with SqlBulkCopy,I got a Exception

"System.InvalidOperationException:“无法访问目标表“User”。""(The target table "User" could not be accessed.)

and the inner exception is

"SqlException: 关键字 'User' 附近有语法错误。"(There is a syntax error near the keyword 'User'.)

[Wraith2]

The word user is a keyword in TSQL. The query syntax you're using is wrong, consider escaping the table name as [user] or choosing another table name. This isn't a driver issue it's a syntax error.

[cheenamalhotra]

I'm looking towards a potential fix in NetCore here:

SqlClient/src/Microsoft.Data.SqlClient/netcore/src/Microsoft/Data/SqlClient/SqlBulkCopy.cs

Line 535 in e1e3be4

updateBulkCommandText.AppendFormat("insert bulk {0} (", this.DestinationTableName);

and in NetFx here:

SqlClient/src/Microsoft.Data.SqlClient/netfx/src/Microsoft/Data/SqlClient/SqlBulkCopy.cs

Line 630 in e1e3be4

updateBulkCommandText.AppendFormat("insert bulk {0} (", this.DestinationTableName);

to change to:

updateBulkCommandText.AppendFormat("insert bulk {0} (", "[" + this.DestinationTableName + "]");

Somewhere on these lines. I'll give it a try and create a PR soon.

[Wraith2]

If you want to escape it you probably want to use make SqlCommand.ParseAndQuoteIdentifier internal and then call it, it uses the name parser to sort out multi dotted identifiers and avoid accidental double escaping.

[yukiwongky]

@hlkitty Attached is the nupkg with the fix from PR #246. Please verify if the fix works for you.
Microsoft.Data.SqlClient.1.1.0-dev.zip

[xinbingyiran]

@hlkitty Attached is the nupkg with the fix from PR #246. Please verify if the fix works for you.
Microsoft.Data.SqlClient.1.1.0-dev.zip

@v-kaywon I download this and replaced with the nupkg,and it seems to be working well