does not find MySQL.Data

[meawmere]

my code:

using (var conn = new MySqlConnection(conn_str))
{
    conn.Open();
    string sql = "INSERT INTO " + settings.Mysql_table_name + " VALUES (\"" + data.Skin + "\", \"" + data.SteamId64 + "\", " + data.Timestamp + ")";
    new MySqlCommand(sql, conn).ExecuteNonQuery();
}

misstake:

19:41:23 [EROR] (cssharp:Core) Error invoking callback
System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation.
 ---> System.IO.FileNotFoundException: Could not load file or assembly 'MySql.Data, Version=8.0.16.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d'. The system cannot find the file specified.

File name: 'MySql.Data, Version=8.0.16.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d'
   at DropSkinsByMeawmere.source.Events.My_events.register_drop(String skin, String SteamId64, CCSPlayerController player)
   at DropSkinsByMeawmere.source.Events.My_events.drop(String skin) in C:\Users\meawmere\source\repos\DropSkinsByMeawmere\DropSkinsByMeawmere\source\Events\My_events.cs:line 64
   at DropSkinsByMeawmere.source.Events.My_events.round_start(EventRoundStart event, GameEventInfo info) in C:\Users\meawmere\source\repos\DropSkinsByMeawmere\DropSkinsByMeawmere\source\Events\My_events.cs:line 53
   at System.RuntimeMethodHandle.InvokeMethod(Object target, Void** arguments, Signature sig, Boolean isConstructor)
   at System.Reflection.MethodBaseInvoker.InvokeDirectByRefWithFewArgs(Object obj, Span`1 copyOfArgs, BindingFlags invokeAttr)
   --- End of inner exception stack trace ---
   at System.Reflection.MethodBaseInvoker.InvokeDirectByRefWithFewArgs(Object obj, Span`1 copyOfArgs, BindingFlags invokeAttr)
   at System.Reflection.MethodBaseInvoker.InvokeWithFewArgs(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
   at System.Delegate.DynamicInvokeImpl(Object[] args)
   at CounterStrikeSharp.API.Core.FunctionReference.<CreateWrappedCallback>b__18_0(fxScriptContext* context) in /home/runner/work/CounterStrikeSharp/CounterStrikeSharp/managed/CounterStrikeSharp.API/Core/FunctionReference.cs:line 100

I tried to throw MySql.dll into the project but it didn't help in any way

[KillStr3aK]

Hey!

You either have to ship the dependencies with the plugin, or put them in the shared folder in the same way you do with plugins

for e.x.: shared/MySql.Data/MySql.Data.dll

[KillStr3aK]

the dependencies are required in runtime context, not just compiling time
third party libraries are not packed in your dll via that command

[antero-lukkonen]

If by 3rd party you mean nuget package dependencies then they all should appear in the output folder and everything then in the output must be copied to the plugin folder.

I apologise if i misunderstand the problem, i see it as a generic
https://learn.microsoft.com/en-us/dotnet/core/tools/dotnet-publish question, given the problem description.

[KillStr3aK]

The exception you get is because of missing dlls, you either need to upload every dependency with the plugin, or upload them to the shared folder (the latter is preferred because many plugins could rely on the same assembly, rather than upload them for every plugin)

you might want to try <CopyLocalLockFileAssemblies>true</CopyLocalLockFileAssemblies> (add to .csproj property tag) as not everything is copied on build (build != publish)

[KillStr3aK]

Also dont forget that if you use the shared folder method, every dll must be placed in their own responsible folder with the same name as the dll

[meawmere]

thanks you!