Chapter 10. ADO.NET
If you have ever read any programming books related to Microsoft development technologies, you have already read a chapter just like this one. It seems that every Windows programming book has an obligatory chapter on database interaction. The reason for this widespread coverage comes as no surprise: Microsoft comes out with a new database technology every two years or so.
If you are new to Windows development, you havenât yet been briefed on the following sometimes conflicting, sometimes complementary database interaction tools:
ODBCâOpen DataBase Connectivity
ISAMâIndexed Sequential Access Method
DAOâData Access Objects
RDOâRemote Data Objects
OLE DBâObject Linking and Embedding for Databases
ADOâActiveX Data Objects
When you look at this list, you might think, âWow, thatâs great. There are so many options to choose from.â You would be foolish to think this. This list isnât great; itâs terrible. Imagine, just for a moment, that we werenât talking about database interfaces, but about other, more practical issues. What if you had to replace the engine in your car every two years? What if the steering column had to be replaced annually? What if you had to replace the oil every 3,500 miles or three months, whichever came first? Could you imagine life in such a world?
Whenever Microsoft introduced a new database object technology into the mix, it was quickly followed by a flurry of reprogramming to bring older âlegacyâ Visual Basic (and other) ...
Get Programming Visual Basic 2008 now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.