Hi, all. I used to be an avid database programmer during the dBase III days, when we used flat .dbf files. It was simple.
I understand coding. I understand fields, types and keys. I understand relations.
What I don't get is the drastic change in mechanics since the old days. Things like access strings, links, adapters, JET vs. OLE, etc. This stuff just did not exist and most tutorials seem to assume it is already known. Not to mention the differences in features between MySQL, SQLLite, Access, etc. and why you might pick one over the other.
I call all this the mechanics (the under the hood stuff). Does anyone know of a good tutorial, so I can get past square one and start some coding?
For example, in Vis. C#, if you want to link to a database, it asks what type data model I want to use. Dataset or Entity Data. What are these? That is one question. It assumes you already have a database created. What tools would I use to create what kinds of databases? That is another. The list goes on, but all this stuff is just mechanics.