Deploy loads all dll's in dacpac directory. Never unloads them.

[MrMikeJJ]

• SqlPackage or DacFx Version: DacFx 162.4.92
• .NET Framework (Windows-only) or .NET Core: Net 8.0
• Environment (local platform and source/target platforms): Windows 10, ran locally.

Steps to Reproduce:

1. Build a SqlProj file, so it creates a dacpac (it also creates a dll).
2. Put some random dll's in the directory where the dacpac resides.
3. Deploy the dacpac
4. When the deploying has finished try deleting any of the dll's in the directory

Note: You can see that all the dll's in that directory has been loaded into the process using Process Explorer.

Did this occur in prior versions? If not - which version(s) did it work in? Unsure

Expected behaviour After deployment is complete, all dll's loaded by the deployment should be unloaded and you should be able to delete any file in the dacpac directory without having to restart the program.

Potentially bad work around Delete all dll's in the directory before calling Deploy. (Is the dll produced by the DacPac build actually used ? Deploy still works without it)

thanks Mike