Database Access via C# ADO.NET
Databases and Object-Oriented Languages
Before minicomputers and PCs came along, the world of IT was simpler. Back then, it was thought that only the very largest of organizations would ever need computing technology. Fast-forward to 2009, when we all have mobile phones with enough computing power to send a rocket to the moon. Nowadays, computing power, software, storage, and bandwidth are all commodity items. However, there still is precious little unity in the computer industry. Interestingly, this lack of a single universal platform has probably done a great deal to foster creativity and invention in the broader industry. In terms of software standards, we have an impressive list of choices; just look at the vibrant open source movement and hugely popular platforms such as Linux and the iPhone. If we had only one operating system and one main programming language, there would be less competitionwhich usually also means less choice.
Even the world of relational databases offers a wide variety of competing products. Programmatic access to these database products also presents many choicesJava Persistence API (JPA)/Hibernate, C++, C#, Java, and so on. In this article, we'll examine C#, and the ADO.NET technology in particular, to see what this technology set offers to the discerning programmer. If you're not too familiar with databases, don't worrywe'll take it from the ground up.
Let's wade in and deploy a database product.