ADO.NET and LINQ
What's in this chapter?
The architecture of ADO.NET
How ADO.NET connects to databases
Using ADO.NET to retrieve data
Using ADO.NET to update databases
Creating and using transactions
Wrox.com Code Downloads for this Chapter
The wrox.com code downloads for this chapter are found at www.wrox.com/remtitle.cgi?isbn=9781118314456 on the Download Code tab. The code is in the chapter 9 download and individually named according to the code file names throughout the chapter.
ADO.NET 1.x was the successor to ActiveX Data Objects 2.6 (ADO). The goal of ADO.NET 1.x was to enable developers to easily create distributed, data-sharing applications in the .NET Framework. The goals of ADO.NET today are to improve the performance of existing features in ADO.NET 1.x, to provide easier use, and to add new features without breaking backward compatibility.
ADO.NET 1.x was built upon industry standards such as XML and XSD, and it provided a data-access interface to communicate with data sources such as SQL Server and Oracle. ADO.NET 4.5 continues to build upon these concepts, while increasing performance. Applications can use ADO.NET to connect to these data sources and retrieve, manipulate, and update data. ADO.NET 4.5 does not break any compatibility with ADO.NET 2.0 or 1.x; it only adds to ...