Exception Loading System.Memory.dll from System.Data.SqlClient

Allanjb 246

While executing an SqlConnection.Open() command in Debug, I get the following exception:
"Could not load file or assembly 'System.Memory, Version=4.1.0.0, Culture=neutral, PublicKeyToken=cc7b13ffcd2ddd51'. The system cannot find the file specified.":"System.Memory, Version=4.1.0.0, Culture=neutral, PublicKeyToken=cc7b13ffcd2ddd51"

In the Output Window I get:
"Exception thrown: 'System.IO.FileNotFoundException' in System.Data.SqlClient.dll"

When running the App in release mode, I don't get any exceptions and the App runs as expected.
I have tried all the usual things like reinstalling System.Data.SqlClient and deleting all the bin and obj files, to no avail.
I am using Visual Studio 2019 with all the latest builds so puzzled as to what is happening.

If I copy the version of system.memory.dll in the release folder to the debug folder and overwrite the copy in debug, everything works fine.
The copy in the release folder is dated: 20-Nov-20, v4.6.29301.02
The copy in the debug folder is dated 19-Feb-20, v4.6.28619.01

Roy Li - MSFT 32,231 Reputation points Microsoft Vendor

2021-08-16T03:16:15.417+00:00

This is an interesting question. Could you please tell me if this issue happens in another blank project using System.Data.SqlClient as well? As a test, do you have other devices to check if your project could run correctly in debug mode on these devices?
Allanjb 246 Reputation points

2021-08-17T18:02:52.883+00:00

I was able to load and run the Northwind dbase example without any problems.
Roy Li - MSFT 32,231 Reputation points Microsoft Vendor

2021-08-18T06:16:27.337+00:00

So have you tried to run your project on other devices? Since you could run the Northwind dbase example, the problem seems to be related to the project itself.
Allanjb 246 Reputation points

2021-08-21T01:50:34.523+00:00

The application is a desktop app and is built on the desktop. I will try rebuilding from my Git repository to a new sandbox, (folder).
Also I will try to run on my notebook.
I was hoping someone would have insight into how to set the version to use in my build file .csproj.
Roy Li - MSFT 32,231 Reputation points Microsoft Vendor

2021-08-23T09:06:11.073+00:00

Please let me know if you have tested on other devices.
Allanjb 246 Reputation points

2021-08-26T15:43:32.32+00:00

I rebuilt the app on my C drive by creating a Git clone, everything works fine.
The strange thing is that the system.memory.dll file is not in my build folder.
The app seems to run fine without it though.
Laxmikant 216 Reputation points

2021-08-30T05:56:27.89+00:00

try to uninstall and re-install the nugget package - System.Memory
Allanjb 246 Reputation points

2021-10-02T01:53:19.473+00:00

Hi: The only way I can get rid of this is to rebuild the app in another folder from scratch.
In the original build I was pulling in packages and then removing/updating and I think this is where it got messy.