ADO.NET

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:

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.

 

Web Services and Service-Oriented Architectures
Online articles>
Consulting
Mentoring
Speaking
Suggested programs
Stencils for the Savvy Manager's Guide
Links
Mail list
Privacy policy
Sitemap
Contact
Web Services articles
XML standards and vocabularies
Application server articles
Database concepts and standards>
Object database articles
Relational database articles
Object-relational mapping articles
XML database articles
XML middleware articles
Article Sponsorship
Reprint policy
Basic concepts for using a DBMS
Database models
DBMS standards>
Article suggestions
SQL-92
JDBC
SQLJ
SQL:1999
ADO.NET>
Java Data Objects (JDO)
ODMG 3.0
Detailed comparison of ODMG 3.0 and JDO
Summary comparison of DBMS standards

Related recent articles from Google News


ADO.NET 3.5 Cookbook
Kansas City infoZine, MO - Apr 28, 2008
Sebastopol, CA - infoZine - ADO.NET 3.5 Cookbook Sebastopol, CA-Microsoft ADO.NET 3.5 is the latest data access technology from Microsoft. ...

SYS-CON Media

DataDirect Builds Custom ADO.NET Providers for Pervasive ...
SYS-CON Media, NJ - Apr 16, 2008
DataDirect Technologies? custom built DataDirect Connect for ADO.NET data providers and the DataDirect Connect for ADO.NET product line use 100 percent ...

Stimulsoft announces Stimulsoft Reports.Net 2008.1
Programmers Heaven.com, Sweden - Apr 14, 2008
You can link with data from MS SQL, Oracle, ODBC, OleDB, FirebirdSQL, and PostgeSQL without using ADO.Net or make compound sql queries to databases with use ...

Data Points
MSDN Magazine - May 2, 2008
The EntityClient provider has a series of objects that should be familiar to you if you know the ADO.NET object model. EntityConnection is used to connect ...

Rage Against Retirement
Redmond Developer News, CA - Apr 18, 2008
NET uses ADO.NET -- and about the only thing those data APIs have in common is the first three letters of their names. Some migration tools include big ...

More related news: ADO.NET - Google News

Related books at Amazon.com


Programming Microsoft® ADO.NET 2.0 Core Reference
by David Sceppa
Average Customer Review: 4.5 stars based on 6 reviews.
Customer Review: I am a huge ADO.NET nut and David's first book was absolutely priceless. After his last book, he set a very high bar that was going to be hard to meet, yet that's exactly what he did. Pros: - He discusses every facet of the ADO.NET library and does it well - He doesn't shy away from difficult topics and in particular, goes straight a...

Murach's ADO.NET 2.0 Database Programming with VB 2005
by Anne Boehm
Average Customer Review: 5 stars based on 10 reviews.
Customer Review: I am a C# developer but when I started browsing this book I couldn't help it but to continue reading it. It is not only about the VB language itself, but instead, how to use it so solve software problems. It teaches how to better write software, best practices and approaches. This book doesn't cover all the theory in the world about...

ADO.NET 3.5 Cookbook (Cookbooks (O'Reilly))
by Bill Hamilton
Average Customer Review: 5 stars based on 1 review.
Customer Review: (Full Disclosure: I was a tech reviewer for this book and received a free copy) I've been using the various incarnations of Microsoft data access technologies for quite some time and have been using ADO.NET for a few years, so I wondered whether I was going to learn anything new from this book. It covers all of the territory to get st...

Programming the Microsoft® ADO.NET Entity Framework (PRO-Developer) (PRO-Developer)
by David Sceppa
Publisher: Microsoft Press
Publication Date: July 2008

Microsoft ADO.NET 2.0 Step by Step (Step By Step (Microsoft))
by Rebecca Riordan
Average Customer Review: 3 stars based on 17 reviews.
Customer Review: My college textbook coverage of ADO.NET left me with more questions than answers, so I searched for other resources. I thought I had learned how to read the book reviews on Amazon.com and have used them as a guide for buying in the past. So when I read the review for this book, I initially gave it a pass and purchased "Programming M...

More related books: Search Amazon.com for ADO.NET

 

Copyright © 2000-2008 Barry & Associates, Inc. All Rights Reserved.
You can use this material for your work or classes. Click here for our reprint policy.
www.service-architecture.com

 

 Information on becoming a sponsor

 

 

Google

 

Barry & Associates, Inc.