Free and affordable online or distance Microsoft® ADO.NET courses, tutorials, tips, how-to articles, tests, exams, books, degree information and resources.

Privacy Statement

All Topics  >  Computers  >  ADO.NET

PC Specialist or PC Maintenance and Repair Program

Penn Foster. Affordable, at-home, accredited training.

Request Free Information.  Train at your own pace with Penn Foster Career School Career School.  Study online, in print, or in combination. You decide which method best suits your learning style.

Personal Computer Specialist Program
Click Here for Free Career Information! - Stratford Career Institute is one of the world’s premier correspondence schools and is an innovative leader in the field of distance education. With distance education you can study at home in your spare time without disrupting your current job or your family life - there are no classes to attend.

IT Pathway Certificate Kaplan University

Request free catalog.  This program provides you with foundational knowledge of key information technology areas, including computer hardware, the Internet, databases, computer programming, and networking.  Holders of this certificate may pursue entry-level employment as a computer operator, a help-desk technician, or a customer service representative.

ADO.NET Overview
ADO.NET is an evolution of the ADO data access model that directly addresses user requirements for developing scalable applications. It was designed specifically for the web with scalability, statelessness, and XML in mind.

The ADO.NET Tutorial
ADO.NET is an object-oriented set of libraries that allows you to interact with data sources. Commonly, the data source is a data base, but it could also be a text file, an Excel spread sheet, or an XML file. For the purposes of this tutorial, we will look at ADO.NET as a way to interact with a data base.

Data Access With ADO.NET

With ADO, creating parameters was a one line process which, while still tedious, was much easier to maintain and read. Spending three lines per parameter may not seem like a big deal, but it gets old really fast, let me assure you (especially when you have to convert over a hundred sp's into DAL methods).

Data Access with ADO.NET - Part 1

This series of articles will first be a simple overview of what ADO.NET is, and second, will be a look at the specific objects and functionality that make up ADO.NET as a whole. My hope is that this series of articles will be beneficial to intermediate as well as advanced developers who are moving to .NET. Any prior knowledge of ADO and ASP.NET will be particularly helpful.

ADO.NET's DataSet

The DataSet is actually an in-memory view of the database. It can contain multiple DataTable and DataRelation objects. This allows developers to navigate and manipulate the collection of tables and their relationships. ADO.NET involves disconnected DataSets as it is modeled for a distributed architecture. As the DataSet itself is disconnected from the data source, it must provide a way to track changes to itself.

Microsoft, MSN, and Windows are either registered trademarks or trademarks of Microsoft Corporation in the United States and/or other countries.

Site Map  •  FAQs  •  Link to Us  •  Educational Gift Ideas  •  Add a Course  •  Contact Us

© 2008 Learning Link Finders, Inc. - All Rights Reserved - Modified on 01/01/08

All trademarks and registered trademarks appearing on the Docnmail.com website are the property of their respective owners.
By providing links to other sites, Learning Link Finders, Inc. does not guarantee, approve or endorse the information or products available
at these sites, nor does a link indicate any association with or endorsement by the linked site to Docnmail.com.