Упаковка в один файл драйвера mysql от Oracle?

Question

[Владимир Коротенко]

В общем проблема подкралась откуда не ждал.
При публикации приложения в режиме одного файла, выскакивает ошибка о неподдерживаемом фреймворке, но при обычной сборке и отладки ничего.
Временно решил заменой на pomelo.

Возможно нужно добавить какие то секции в проект?

Кто нибудь сталкивался?

Окружение net core 3.1

Вот пример который повторяет этот баг
https://github.com/vkorotenko/DriverTest

Comments

[Василий Банников]

А в чём проблема с Pomelo? Версия MySql.Data последняя?
Имхо, смотря на количество зависимостей - я бы не взял оракловый драйвер.

[Владимир Коротенко]

Василий Банников,

Build started...
1>------ Build started: Project: TestMySqlOracle, Configuration: Release Any CPU ------
1>TestMySqlOracle -> C:\Users\kvn\source\repos\DriverTest\TestMySqlOracle\bin\Release\netcoreapp3.1\TestMySqlOracle.dll
2>------ Publish started: Project: TestMySqlOracle, Configuration: Release Any CPU ------
2>Determining projects to restore...
2>Detected package downgrade: System.Diagnostics.Debug from 4.3.0 to 4.0.11. Reference the package directly from the project to select a different version. 
2> TestMySqlOracle -> MySql.Data 8.0.22 -> SSH.NET 2016.1.0 -> System.IO.FileSystem 4.0.1 -> runtime.win.System.IO.FileSystem 4.3.0 -> System.Diagnostics.Debug (>= 4.3.0) 
2> TestMySqlOracle -> MySql.Data 8.0.22 -> SSH.NET 2016.1.0 -> System.Diagnostics.Debug (>= 4.0.11)
2>Detected package downgrade: System.IO.FileSystem.Primitives from 4.3.0 to 4.0.1. Reference the package directly from the project to select a different version. 
2> TestMySqlOracle -> MySql.Data 8.0.22 -> SSH.NET 2016.1.0 -> System.IO.FileSystem 4.0.1 -> runtime.win.System.IO.FileSystem 4.3.0 -> System.IO.FileSystem.Primitives (>= 4.3.0) 
2> TestMySqlOracle -> MySql.Data 8.0.22 -> SSH.NET 2016.1.0 -> System.IO.FileSystem.Primitives (>= 4.0.1)
2>Detected package downgrade: System.Runtime.Extensions from 4.3.0 to 4.1.0. Reference the package directly from the project to select a different version. 
2> TestMySqlOracle -> MySql.Data 8.0.22 -> SSH.NET 2016.1.0 -> System.IO.FileSystem 4.0.1 -> runtime.win.System.IO.FileSystem 4.3.0 -> System.Runtime.Extensions (>= 4.3.0) 
2> TestMySqlOracle -> MySql.Data 8.0.22 -> SSH.NET 2016.1.0 -> System.Runtime.Extensions (>= 4.1.0)
2>Detected package downgrade: System.Threading from 4.3.0 to 4.0.11. Reference the package directly from the project to select a different version. 
2> TestMySqlOracle -> MySql.Data 8.0.22 -> SSH.NET 2016.1.0 -> System.IO.FileSystem 4.0.1 -> runtime.win.System.IO.FileSystem 4.3.0 -> System.Threading (>= 4.3.0) 
2> TestMySqlOracle -> MySql.Data 8.0.22 -> SSH.NET 2016.1.0 -> System.Threading (>= 4.0.11)
2>Detected package downgrade: System.Diagnostics.Debug from 4.3.0 to 4.0.11. Reference the package directly from the project to select a different version. 
2> TestMySqlOracle -> MySql.Data 8.0.22 -> SSH.NET 2016.1.0 -> System.Net.Sockets 4.1.0 -> runtime.win.System.Net.Sockets 4.3.0 -> System.Diagnostics.Debug (>= 4.3.0) 
2> TestMySqlOracle -> MySql.Data 8.0.22 -> SSH.NET 2016.1.0 -> System.Diagnostics.Debug (>= 4.0.11)
2>Detected package downgrade: System.Globalization from 4.3.0 to 4.0.11. Reference the package directly from the project to select a different version. 
2> TestMySqlOracle -> MySql.Data 8.0.22 -> SSH.NET 2016.1.0 -> System.Net.Sockets 4.1.0 -> runtime.win.System.Net.Sockets 4.3.0 -> System.Globalization (>= 4.3.0) 
2> TestMySqlOracle -> MySql.Data 8.0.22 -> SSH.NET 2016.1.0 -> System.Globalization (>= 4.0.11)
2>Detected package downgrade: System.IO.FileSystem from 4.3.0 to 4.0.1. Reference the package directly from the project to select a different version. 
2> TestMySqlOracle -> MySql.Data 8.0.22 -> SSH.NET 2016.1.0 -> System.Net.Sockets 4.1.0 -> runtime.win.System.Net.Sockets 4.3.0 -> System.IO.FileSystem (>= 4.3.0) 
2> TestMySqlOracle -> MySql.Data 8.0.22 -> SSH.NET 2016.1.0 -> System.IO.FileSystem (>= 4.0.1)
2>Detected package downgrade: System.IO.FileSystem.Primitives from 4.3.0 to 4.0.1. Reference the package directly from the project to select a different version. 
2> TestMySqlOracle -> MySql.Data 8.0.22 -> SSH.NET 2016.1.0 -> System.Net.Sockets 4.1.0 -> runtime.win.System.Net.Sockets 4.3.0 -> System.IO.FileSystem.Primitives (>= 4.3.0) 
2> TestMySqlOracle -> MySql.Data 8.0.22 -> SSH.NET 2016.1.0 -> System.IO.FileSystem.Primitives (>= 4.0.1)
2>Detected package downgrade: System.Net.Primitives from 4.3.0 to 4.0.11. Reference the package directly from the project to select a different version. 
2> TestMySqlOracle -> MySql.Data 8.0.22 -> SSH.NET 2016.1.0 -> System.Net.Sockets 4.1.0 -> runtime.win.System.Net.Sockets 4.3.0 -> System.Net.Primitives (>= 4.3.0) 
2> TestMySqlOracle -> MySql.Data 8.0.22 -> SSH.NET 2016.1.0 -> System.Net.Sockets 4.1.0 -> System.Net.Primitives (>= 4.0.11)
2>Detected package downgrade: System.Runtime.Extensions from 4.3.0 to 4.1.0. Reference the package directly from the project to select a different version. 
2> TestMySqlOracle -> MySql.Data 8.0.22 -> SSH.NET 2016.1.0 -> System.Net.Sockets 4.1.0 -> runtime.win.System.Net.Sockets 4.3.0 -> System.Runtime.Extensions (>= 4.3.0) 
2> TestMySqlOracle -> MySql.Data 8.0.22 -> SSH.NET 2016.1.0 -> System.Runtime.Extensions (>= 4.1.0)
2>Detected package downgrade: System.Threading from 4.3.0 to 4.0.11. Reference the package directly from the project to select a different version. 

2> TestMySqlOracle -> MySql.Data 8.0.22 -> BouncyCastle.NetCore 1.8.3 -> NETStandard.Library 1.6.0 -> System.Net.Primitives 4.0.11 -> runtime.win.System.Net.Primitives 4.3.0 -> System.Runtime.Extensions (>= 4.3.0) 
2> TestMySqlOracle -> MySql.Data 8.0.22 -> BouncyCastle.NetCore 1.8.3 -> NETStandard.Library 1.6.0 -> System.Runtime.Extensions (>= 4.1.0)

2> TestMySqlOracle -> MySql.Data 8.0.22 -> SSH.NET 2016.1.0 -> System.Net.Sockets 4.1.0 -> System.Net.Primitives 4.0.11 -> runtime.win.System.Net.Primitives 4.3.0 -> System.Threading (>= 4.3.0) 
2> TestMySqlOracle -> MySql.Data 8.0.22 -> SSH.NET 2016.1.0 -> System.Threading (>= 4.0.11)
2>Failed to restore C:\Users\kvn\source\repos\DriverTest\TestMySqlOracle\TestMySqlOracle.csproj (in 1,85 sec).
========== Build: 1 succeeded, 0 failed, 0 up-to-date, 0 skipped ==========
========== Publish: 0 succeeded, 1 failed, 0 skipped ==========

[Василий Банников]

> Detected package downgrade
Вот из-за этого я не люблю пакеты с большим количеством зависимостей.
Явно указать в зависимостях эти пакеты с более новыми версиями.