LINQPad 5 - Issues using Microsoft.Data.SqlClient in fretje.SqlBulkTools.

I'm trying to test out the library fretje.SqlBulkTools in LINQPad 5 since I plan to implement it in an existing .NET Framework project. When I load this particular project which targets .Net Standard, it also requires the use of Microsoft.Data.SqlClient instead of System.Data.SqlClient. This causes two issues.

1) I can't seem to remove the 'implicit' reference to System.Data.SqlClient - I have to fully qualify Microsoft.Data.SqlClient.* in my test code.

2) Even when I manually fully qualify, I get an error message when trying to run the query.

Unable to load DLL 'Microsoft.Data.SqlClient.SNI.x64.dll': The specified module could not be found. (Exception from HRESULT: 0x8007007E)

I attempted to do the same thing in Visual Studio 2019 and it worked without issue, so there's something about this interaction that specifically doesn't work in LINQPad. Thanks!


Sign In or Register to comment.