ADO .NET programming has a special connection with Visual Studio .NET, and we'll see both packages at their best and most powerful in this book.
These two packagesADO .NET and Visual Studio .NETare specifically designed to work together. Visual Studio bends over backward to make using ADO .NET easy, and I'll cover the Visual Studio .NET database tools like the Project Explorer, the various data adapter and dataset configuration tools, the query builder, and more in depth. In fact, the natural environment for ADO .NET programming is Visual Studio .NETand I think you'll agree as you read this book.
If this book is titled ADO .NET Programming in Visual Basic .NET , why do I keep referring to Visual Studio? Well, in the past, VB (and its variants, VBScript and VB For Applications) was the most natural environment for ADO database programming. The other Visual Studio tools (Visual C++, Visual Interdev, Visual FoxPro) could all use ADO, but since ADO was designed around the COM (Component Object Model) architecture, VB was the easiest way to use the package. With the advent of Visual Studio .NET, this has all changed.
Visual Studio .NET no longer uses COM as its underlying architecture. Instead it uses the Extensible Markup Language (XML) and Simple Object Access Protocol (SOAP). (You can still use your old COM objects in .NET, even ADO, but that is outside the scope of this book.) The common language runtime (CLR) interpreter allows all of the managed languages (VB, Managed C++, and C#) to utilize a common set of data types and interfaces so they can all use the same objects interchangeably. In fact, you can write components in C# and use them in VB and vice-versa. So while we will use VB .NET syntax in all of the examples and demonstrations in the book, the principles we are sharing will apply equally to C#.