Connecting to MySQL Database

Download and install either the ODBC or .NET connector from this page:  https://dev.mysql.com/downloads/connector/

My reference for all connection strings
https://www.connectionstrings.com/mysql/

I have already installed MySQL .NET connector on my Windows OS. About the connection string, I selected one of the examples of connectionstrings.com page.

Have you created the appropriate user for your database?

Have you actually decided on a particular methodolgy for handling your Data Layer. You can go 'old-school' here and use the the Commands and DataReaders etc, or you can use an ORM such as Entity Framework. Personally I prefer the ORM as it tends to remove most of the actual DB stuff away from the developer. You simply create classes representing your table, and then you request instances of those objects from the EF Context. To add a item to the db, you create a new instance, add it to the DBSet and save it. Quick C# example, but I don't think it's a whole lot different in VB

// Loop through the users table
using (var db as new AppContext()) {
    foreach (var user in db.Users) {
        // user->FirstName;
        // user->LastName;
    }
}

Select allOpen in new window

// Insert a new User
var user = new User {
    FirstName = "Chris",
    LastName = "Stanyon",
}

using (var db as new AppContext()) {
    db.Users.Add(user);
    db.SaveChanges();
}

Select allOpen in new window

Yes. I created the correct user for the database.
Im looking for a Crud sample using this language and this database. Anyone can share with me a sample to see how it works?.

Regards,