Loading...
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 [...]
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 [...]
October 9, 2008
The Design Decomposition Blog
is written by Doug Barry.
Loading...

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.

Loading...

Related recent articles from Google News

Stone Bond Technologies releases Enterprise Enabler® Version 7.0, next ...
Bradenton Herald
Enterprise Enabler enhances the capability of dashboards, business intelligence, analytics and SharePoint through standard ADO.Net interface, eliminating ...
and more »
31 Aug 2010 at 11:23pm
Cover Story: Get Ready for the Entity Framework
Redmond Developer News
The ADO.NET Entity Framework 4, updated and released alongside the Microsoft .NET Framework 4 in April, is emerging as the default way to do data access in ...
Vote of Confidence for Entity Framework 4? Redmond Developer News (blog)
all 3 news articles »
31 Aug 2010 at 5:43pm
Stone Bond Technologies releases Enterprise Enabler® Version 7.0, next ...
Business Wire (press release)
Enterprise Enabler enhances the capability of dashboards, business intelligence, analytics and SharePoint through standard ADO.Net interface, eliminating ...
and more »
31 Aug 2010 at 7:01am
Cover Story: Get Ready for the Entity Framework
Visual Studio Magazine
The ADO.NET Entity Framework 4, updated and released alongside the Microsoft .NET Framework 4 in April, is emerging as the default way ...
and more »
30 Aug 2010 at 10:45am
Programming Entity Framework, Second Edition
Kansas City infoZine
Sebastopol, CA - infoZine - Get a thorough introduction to ADO.NET Entity Framework 4—Microsoft's core framework for modeling and interacting with data in ...

24 Aug 2010 at 7:19am
More related news on: ADO.NET

Related books at Amazon.com

Programming Entity Framework: Building Data Centric Apps with the ADO.NET Entity Framework
Programming Entity Framework: Building Data Centric Apps with the ADO.NET Entity Framework
by Julia Lerman
Average Customer Review: 4.5 stars based on 27 reviews.
Customer Review: If you're looking into learning ADO.NET Entity Framework, this is the book to have. The book is concise, very detailed, and well-written-- and that's usually rare to find in most technical books these days. The author often sheds some insights on remote subjects that are related, and gives the most-straightforward answers. Apart fro...
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 22 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.5 stars based on 11 reviews.
Customer Review: '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)' is a good book to prepare yourself for Exam 70-561 ADO.NET Application Development. I'm not going to use the word great due to typos and ...
More related books: Search Amazon.com for ADO.NET