SNOW-1814669: Publishing as SingleFile breaks the Snowflake connector

[hasnik]

1. What version of .NET driver are you using?
   4.2.0

2. What operating system and processor architecture are you using?
   Windows 11 23H2 (build 22631.4460)
   x86_64

3. What version of .NET framework are you using?
   net9.0

4. What did you do?
   Run the app published with dotnet publish --configuration Release --runtime win-x64 --self-contained true -p:PublishSingleFile=true

5. What did you expect to see?
   The app is working the same way as if it is published with dotnet publish --configuration Release --runtime win-x64 --self-contained true

6. What is the actual result?

The path is empty. (Parameter 'path')
   at System.IO.Path.GetFullPath(String path)
   at System.Diagnostics.FileVersionInfo.GetVersionInfo(String fileName)
   at Snowflake.Data.Core.Tools.Diagnostics.AppendAssemblyInfo(StringBuilder info, Assembly assembly, String assemblyTag)
   at Snowflake.Data.Core.Tools.Diagnostics.GetDiagnosticInfo()
   at Snowflake.Data.Core.Tools.Diagnostics.LogDiagnostics()
   at Snowflake.Data.Client.SnowflakeDbConnectionPool.SetConnectionPoolVersion(ConnectionPoolType requestedPoolType, Boolean force)
   at Snowflake.Data.Client.SnowflakeDbConnectionPool.get_ConnectionManager()
   at Snowflake.Data.Client.SnowflakeDbConnectionPool.GetSessionAsync(String connectionString, SecureString password, CancellationToken cancellationToken)
   at Snowflake.Data.Client.SnowflakeDbConnection.OpenAsync(CancellationToken cancellationToken)

7. Problem description
   Snowflake.Data relies on the fact that it is able to locate an assembly and if the app is packaged as a single file it is unable to do so. Is there a way I can pass required information to Snowflake.Data so that it will work when published as a single file?

[sfc-gh-dszmolka]

hello - i'm not sure we intended to support single-file deployment. Let me research on this a bit.

edit: per initial analysis it looks like this is a bug, without workarounds for the moment. We'll look into it.

[hasnik]

Hi! Sure thing, take your time. If your research concludes that you do not intend to support single-file deployment I believe it's a good idea to communicate it explicitly in the documentation.

[sfc-gh-dszmolka]

Team started to look into this, and there's already a PR #1063 with a fix

[sfc-gh-dszmolka]

PR merged and will be part of the next upcoming release cycle