Click here to Skip to main content
15,350,147 members
Please Sign up or sign in to vote.
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.).
Updated 7-Jul-20 17:23pm

1 solution

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
What is the best practice ?
Use paramaterized queries, dont leave yourself open to SQL injection, don't store passwords etc in code
evry1falls 12-Jul-20 17:56pm
Thank you I will try your suggestion and come back to you ASAP

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

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900