I'm currently developing a system with VB.NET, I've been thinking of using either mySQL or Access. However I'm still not sure which database can gives the best performance with VB.NET.
I also found that if I use mySQL I will have to use object such as OdbcCommand which is totally different from the standard object provide such as sqlDataAdapter, sqlCommandBuilder (please tell me if I'm wrong)
please see: http://dev.mysql.com/doc/mysql/en/ODBC.NET(VB).html
Is that meant if I change database one day, I also have to change the code as well. for example: from mySQL to MS SQL Server??
Please tell me which database I should use !! THANKS