- ago
Hello.
I have tried adding the references for MySql.
I have copied the dlls MySql (the same that they are working with WL 6) into the wealth-lab installation folder (C:\Program Files\Quantacula, LLC\Wealth-Lab 7), I have restarted.

I have added on my code
using MySql.Data.MySqlClient;
...........
string MyConString = "SERVER=localhost;" + "DATABASE=mercados;" + "UID=root;" + "PASSWORD='';";
MySqlConnection connection = new MySqlConnection(MyConString);

But imposible, I go to Tools-->Assambly references and MySql.Data.dll and MySql.Web.dll dont appear for selection, but they are included in folder C:\Program Files\Quantacula, LLC\Wealth-Lab 7

I don´t Know how to add pics to the post, if you need it, let me know.
Thanks
0
1,509
Solved
7 Replies

Reply

Bookmark

Sort
- ago
#1
Hello,

WL6 is based on .NET 4.x (v4.6 for 6.9.23 and v4.8 for 6.9.24) whereas WL7 is built on a newer stack: .NET Core 3.1 with a view to upgrade it to 6.0 once it's released.

So you should download the DLLs for the right platform target.
0
- ago
#2
Sorry, I dont understand too much about it.

I got the dlls from here (Connector/NET 8.0.23)
https://dev.mysql.com/downloads/connector/net/

I think they are the latest version, are´t they??
0
- ago
#3
Sorry I don't have much experience with MySQL. No idea if this is the right DLL. My point is: you should make sure you're copying the version built for .NET _CORE_.

Yes it's all a bit confusing. .NET 4.x is legacy technology now. WL7 is built upon a newer tech: .NET Core 3.1. With .NET Core 5 (there wasn't a "Core 4") the framework has again became renamed to .NET without the "Core" (note that this is not support by WL7 yet).
0
- ago
#4
Please if someone is going to use mysql with wl7 for windows 10 (64) and find the solution to put it here, I am unable.

I almost sure that dlls from Connector/NET 8.0.23 are the are the correct ones for NET CORE 3.1
Thanks a lot
0
- ago
#5
You might want to give this a try. It has .NET Core binding:

MySqlConnector: High Performance MySQL Library for .NET

To download go to Nuget and click "Download package". A .nupkg file is merely a ZIP where under /lib/netcoreapp3.1 you'll find the right DLLs.
1
Best Answer
- ago
#6
Working!!!!!!!!!!!!!!!!
If anybody need it:
1.) Extract with winzip/winrar:
lib/netcoreapp3.1/ MySqlConnector.dll

2.) Put MySqlConnector.dll in C:\Program Files\Quantacula, LLC\Wealth-Lab 7

3.) In WL7 go to Tools-->Assambly references
Check:
System.ComponentModel.Primitives
System.Data.Common

4.) Add to your C#code:
using MySqlConnector;

And working!!!
As I always say: Wonderful software, wonderful team.
2
Glitch8
 ( 10.10% )
- ago
#7
Glad you got it working! I was just about to download them and see if I could get them working :)
0

Reply

Bookmark

Sort