1

Hello helpful people!

I've just recieved a new assigment where I am supposed to create an employee, inventory and administration application. I've also got a MySQL-database including all employees, items, orders, customers, history and so on.

Now, my question is how do I approach this? Should create my own classes like "Employee", "Customer" and "Inventory"? Is that the better way, considering that I have to connect the database to VB?

Please excuse me if I am not specific enough, I have little to no experience in programming, but I couldn't find a good answer online that is why I am asking you guys.

Thank you in advance.

Thomas Roesen
  • 73
  • 6

1 Answers1

0

You want to look into Object-relational mapping (ORM)

There are many which you can use. e.g EntityFramework, NHibernate, ServiceStack.OrmLite, Simple.Data

They all all connect to your MySql database and build the Classes automatically. This will save you from manually coding everything.

If you search Stackoverflow for how to use each with MySql there will be many helpful answers.

To start you off with, check out this one which helps with EntityFramework and MySql Using MySQL with Entity Framework

Furthermore, if you want to speed things up even more, then take a look at MVC. You can create pages which allow you to interact with the database with a simple click.

Community
  • 1
  • 1
Tim B James
  • 20,084
  • 4
  • 73
  • 103