Skip to Content
Professional Visual Basic® 2010 and .NET 4
book

Professional Visual Basic® 2010 and .NET 4

by Bill Sheldon, Billy Hollis, Jonathan Marbutt, Gastón C. Hillar, Rob Windsor, Kent Sharkey
May 2010
Beginner
1319 pages
45h 35m
English
Wrox
Content preview from Professional Visual Basic® 2010 and .NET 4

Chapter 10. ADO.NET and LINQ

WHAT YOU WILL LEARN 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

  • Retrieving data with LINQ to SQL

  • Updating databases using LINQ to SQL

ADO.NET 1.x was the successor to ActiveX Data Objects 2.6 (ADO). The main goal of ADO.NET 1.x was to enable developers to easily create distributed, data-sharing applications in the .NET Framework. The main 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.

Note

Throughout this chapter, when ADO.NET is mentioned without a version number after it (that is, 1.x, 2.0, 3.5, or 4), the statement applies to all versions of ADO.NET.

ADO.NET 1.x was built upon industry standards such as XML, and it provided a data-access interface to communicate with data sources such as SQL Server and Oracle. ADO.NET 4 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 does not break any compatibility with ADO.NET 2.0 or 1.x; it only adds to the stack of functionality.

In solutions that require disconnected or remote access to data, ADO.NET uses XML to exchange data between programs or with Web pages. Any component that can read XML can make use of ADO.NET components. ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

Read now

Unlock full access

More than 5,000 organizations count on O’Reilly

AirBnbBlueOriginElectronic ArtsHomeDepotNasdaqRakutenTata Consultancy Services

QuotationMarkO’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.
Julian F.
Head of Cybersecurity
QuotationMarkI wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.
Addison B.
Field Engineer
QuotationMarkI’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.
Amir M.
Data Platform Tech Lead
QuotationMarkI'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
Mark W.
Embedded Software Engineer

You might also like

Pro VB 2010 and the .NET 4 Platform

Pro VB 2010 and the .NET 4 Platform

Andrew Troelsen, Vidya Vrat Agarwal
Professional Visual Basic® 2008

Professional Visual Basic® 2008

Billy Hollis, Bill Evjen, Kent Sharkey, Bill Sheldon

Publisher Resources

ISBN: 9780470502242Purchase book