Newletter Sign Up
Posts on the
Design Decomposition Blog
Iridium Satellite Collision in Space
You might have seen the recent news reports about the collision between U.S. and Russian communication satellites. The U.S. satellite was one of the Iridium satellites. What wasn’t reported and you probably don’t know is that an object database management system (ODBMS) is an important part of the Iridium system. Even though ODBMSs are a [...]
February 13, 2009
(The Acronym) SOA is (Perhaps) Dead (at Some Companies); Long Live Services
I am now also posting on the Cutter Blog. My initial posting is (The Acronym) SOA is (Perhaps) Dead (at Some Companies); Long Live Services. It is a response to Anne Thomas Manes’ SOA is Dead; Long Live Services on her blog at the Burton Group.
January 9, 2009
Atomicity
The typical definition of an atomic task or process is one that cannot be decomposed further. This is vague and subject to interpretation. The Decomposition Matrix on this site uses a specific definition: A task (for business process diagrams) or a process (for data flow diagrams) is atomic if every input relates to every output [...]
December 3, 2008
Well-Formed Business Process Diagrams
My last posting referenced the criteria for a well-formed business process diagram mentioned in Business Process Driven SOA using BPMN and BPEL by Matjaz B. Juric and Kapil Pant. I am going to expand on their criteria to create a more comprehensive definition of a well-formed business process diagram. To start, here are three criteria from [...]
November 18, 2008
Recent Business Process Modeling Books
I recently received two new books on business process modeling. Both books looked interesting because they had great titles. As it turns out, one book is great and the other not so good. The not so good book is Business Process Driven SOA using BPMN and BPEL by Matjaz B. Juric and Kapil Pant. There are [...]
October 9, 2008
The Design Decomposition Blog
is written by Doug Barry.

ADO.NET provides the database access for Microsoft.NET. XML is used in ADO.NET for in-memory middle-tier business objects, or DataSets, built at run-time from EIS-tier databases. The DataSets are a copy of the data in the database and are not actively connected to the underlying databases. This is referred to as a "disconnected" view of the database data. ADO.NET is designed to work with all the languages supported in .NET. ADO.NET can be used with virtually any database management system. 

ADO.NET uses the call-level approach. This is illustrated by the ADO.NET statements in this diagram:

ADO.NET example

An example of a host statement in C# that creates a new Person instance, or DataRow, would be:

DataRow row = ds.Tables["Person"].NewRow(); 

row["ssan"] = "999999999"; 
row["name"] = "Doug Barry"; 

ds.Tables["Person"].Rows.Add(row); 

If you also wanted to manipulate this new Person instance in the host program, you would need C# code in addition to this code fragment that populates the instance in C# along with the instance in the database.

Also see .NET.

Related content for: ADO.NET

More on the general topic: DBMS standards

Read more free articles on this site

There are nearly 400 pages of articles on this site with over 40 pages on database concepts and standards.

Search this site for more articles

Custom Search

Browse this site for more articles

Click on the topics below to browse the articles on this site. You can see more detail by clicking on the arrows. This highlights the location of the current article: ADO.NET.

Related recent articles from Google News

Microsoft Creates New OData.org Website for Open Data Protocol
CMSWire
You may remember hearing "Astoria" Protocol or ADO.NET Data Services Protocol or maybe "our conventions/extensions to AtomPub". All these were other ways ...
and more »
19 Mar 2010 at 9:43am
Microsoft delivers updates on OData, Houston, Dallas
ZDNet (blog)
If you've heard Microsoft use the codename “Astoria” or talk about ADO.Net Data Services in the past, these two codenames are now under the larger OData ...
and more »
16 Mar 2010 at 2:22pm
STEMSOFT Selects Progress DataDirect for High Performance Data Connectivity in ...
MarketWatch (press release)
With full-feature Entity Framework support and 100 percent managed code architecture, the DataDirect Connect for ADO.NET data providers boost application ...
and more »
22 Feb 2010 at 7:06am
Microsoft's constant changing of .NET is not good for the industry; the ...
SDTimes.com
The company's recent decision to shift from LINQ to SQL on the ADO.NET Entity Framework was unsettling to some developers, and it contributed to the ...

1 Mar 2010 at 7:37pm
MIX Day 2 Keynote: Put the Phone Down and Listen
Visual Studio Magazine (blog)
OData is nothing more than the protocol side of "Astoria" (now known as WCF Data Services, and until recently called ADO.NET Data Services) separated out ...

18 Mar 2010 at 9:00am
More related news on: ADO.NET

Related books at Amazon.com

Murach's ADO.NET 3.5, LINQ, and the Entity Framework with C# 2008 (Murach: Training & Reference)
Murach's ADO.NET 3.5, LINQ, and the Entity Framework with C# 2008 (Murach: Training & Reference)
by Anne Boehm
Average Customer Review: 4.5 stars based on 10 reviews.
Customer Review: Written in an instructional style with clear definitions and illustrated concepts this book covers a host of data access concepts with timely and practical examples. The material in the book explains many of the new additions to the Microsoft ADO.Net 3.5 framework such as LINQ (Language-Integrated Query), Entity Framework, and Micro...
Murach's ADO.NET 3.5, LINQ, and the Entity Framework with VB 2008
Murach's ADO.NET 3.5, LINQ, and the Entity Framework with VB 2008
by Anne Boehm
Average Customer Review: 4.5 stars based on 21 reviews.
Customer Review: I purchased this book on the 6/11/09 and received it on 6/17/09 and since I have gotten I can put it down it is very well organized and easy to follow. The perfect book to get you started.
MCTS Self-Paced Training Kit (Exam 70-561): Microsoft .NET Framework 3.5-ADO.NET Application Development: Microsoft .Net Framework 3.5--ADO.NET Application Development (Self-Paced Training Kits)
MCTS Self-Paced Training Kit (Exam 70-561): Microsoft .NET Framework 3.5-ADO.NET Application Development: Microsoft .Net Framework 3.5--ADO.NET Application Development (Self-Paced Training Kits)
by Shawn Wildermuth, Jim Wightman, Mark Blomsma
Average Customer Review: 2 stars based on 9 reviews.
Customer Review: This book is sufficient for passing the exam. This was the only resource I used (aside from MSDN), and I passed the exam. However, I must say that this book will only be sufficient if you have experience with some ADO.NET functionality already - preferably database connections and structuring principles. If you are completely new to ...
ADO.NET 3.5 Cookbook (Cookbooks (O'Reilly))
ADO.NET 3.5 Cookbook (Cookbooks (O'Reilly))
by Bill Hamilton
Average Customer Review: 4.5 stars based on 7 reviews.
Customer Review: The 'ADO.NET 3.5 Cookbook' is a great resource for every .NET database developer out in the world. With 950+ pages of content you will not be reading thin, as this goodies book comes with 222 tidbits of information that will help you in your everyday work. Subjects covered include: - connecting to a variety of data sources - working ...
Programming Microsoft ADO.NET 2.0 Core Reference
Programming Microsoft ADO.NET 2.0 Core Reference
by David Sceppa
Average Customer Review: 4.5 stars based on 11 reviews.
Customer Review: Wow, this is the book I was looking for! David Sceppa did a great job on this book. Programming Microsoft ADO.NET 2.0 is very easy to understand and has a lot of code samples that I can use in my production environment. I learned how to loop through data using ado.net and inserting, updating, and deleting using stored procedures wit...
More related books: Search Amazon.com for ADO.NET