Vb.net mysql.data vs. System.data

Question

1.00/5 (1 vote)

See more:

I'm beginning a new project in Visual Studio 2015, .Net FrameWork 4.8, Win10 32bit, WinForm.
I used to use System.Data.OleDB to work with Microsoft Access Database (mdb and accdb) and it was gr8 also when using Crystal Reports.

Now, I'm supposed to use MySql Database instead of Microsoft Access Database. This is my First time with MySql Database.

My questions are :

Do I use MySql.Data or Use OleDB for MySql ?!
What are the most notable differences Between MySql.Data & Oledb for MySql in developing WinForm app. ?!
What is the best practice ?

What I have tried:

I downloaded MySql Server Full (V. 5.7.30) along with Connector/Net (8.0.20) and MySql for Visual Studio (1.2.9), all at my Laptop (Developer Env.).

Posted 7-Jul-20 8:57am

evry1falls

Updated 7-Jul-20 17:23pm

v2

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Garth J Lancaster · Answer 1 · 2020-07-07T17:23:00

Solution 1

You could start following this MySQL Connection In Windows Application Using VB.NET[^] with references to MySQL :: MySQL Connector/NET Developer Guide :: 4.1 Creating a Connector/NET Connection String[^]

As for

Quote:
What is the best practice ?

Use paramaterized queries, dont leave yourself open to SQL injection, don't store passwords etc in code

Posted 7-Jul-20 17:23pm

Garth J Lancaster

v2

Comments

evry1falls 12-Jul-20 17:56pm

Thank you I will try your suggestion and come back to you ASAP