March 2008
Intermediate to advanced
982 pages
22h 43m
English
Content preview from ADO.NET 3.5 Cookbook, 2nd EditionBecome 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,
O’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.I 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.I’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.I'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.
How This Book Is Organized
This book is organized into 12 chapters, each of which focuses on a particular topic in creating ADO.NET solutions. Each recipe consists of a specific problem, stated as a question, followed by a solution and discussion. Here is a summary of each chapter:
- Chapter 1, Connecting to Data
The solutions in this chapter show how to connect to a variety of data sources from ADO.NET. Connecting to data sources involves connections strings, security-related issues including storing connection strings and how to use them, the different authentication methods available, and how to enable the user to build a connection string at runtime. Solutions show how to set up, monitor, and optimize connection pooling, and how to use transactions with pooled connection.
- Chapter 2, Working with Disconnected Data Objects
ADO.NET includes both connected and disconnected classes. The solutions in this chapter explain how to work with the ADO.NET disconnected classes—
DataColumn, DataTable, DataSet, unique constraint, primary key, foreign key, andDataRelation. You will also learn aboutDataRowarrays, how to access data in them, and how to convert between aDataRowarray andDataTable. Finally, you will learn about strongly typedDataSetobjects, how to create them, and how to customize aspects of them.- Chapter 3, Querying and Retrieving Data
The solutions in this chapter show how to retrieve data and schemas using SQL statements, parameterized SQL statements, parameterized stored procedures, ...
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
O’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.
I 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.
I’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.
I'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.