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.).