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.
Chapter 5. Adding and Modifying Data
5.0. Introduction
This chapter focuses on issues related to adding and editing, and persisting data changes to the data source. An overview of some of the topics in this chapter follows.
ADO.NET provides an autoincrementing column type that generates a unique value for each new row. There is no mechanism to ensure that the values are unique from the values produced by other users. Recipe 5.1 shows how to use autoincrementing columns to ensure that the values generated by different users do not conflict.
SQL Server has an identity column that is also an autoincrementing column type. This value is used rather than the ADO.NET autoincrement column type when adding new records; there is no automatic way to keep these values synchronized after new rows in a DataTable have been inserted into a SQL Server table. Recipe 5.2 shows you how to synchronize the DataTable to the values in the database. Recipe 5.3 shows you how to synchronize these values with a Microsoft Access database.
Oracle does not support autoincrement columns but rather uses a sequence, that is, a procedure that generates a series of unique values. Recipe 5.4 shows how to synchronize autoincrementing columns in a DataTable with Oracle sequence values after a row has been inserted into an Oracle database.
Recipe 5.8 shows how to add master-detail records to a DataSet where the primary key of the parent table is an autoincrementing column.
A Globally Unique Identifier (GUID) is a 128-bit integer ...
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.