The ADO.NET of the .NET Framework

By: Christine Layug
Submitted: 2008-06-23 17:22:14
Print this article | Tell a friend | For publisher | Social Bookmarking
Rating:
 

ADO.NET is a set of computer software components that can be used by programmers to access data and data services. It is a part of the base class library that is included with the Microsoft .NET Framework.

It is commonly used by programmers to access and modify data stored in relational database systems, though it can also be used to access data in non-relational sources. ADO.NET is sometimes considered an evolution of ActiveX Data Objects (ADO) technology, but was changed so extensively that it can be conceived of as an entirely new product.

ADO.NET consists of two primary parts: its Data Provider and its DateSets.

The ADO.NET Data provider classes provide access to a data source, such as a Microsoft SQL Server or Oracle database and OLEDB data provider. Each data source has its own set of provider objects, but they each have a common set of utility classes:

Connection: Provides a connection used to communicate with the data source. Also acts as an abstract factory for command objects.

Command: Used to perform some action on the data source, such as reading, updating, or deleting relational data.

Parameter: Describes a single parameter to a command. A common example is a parameter to a stored procedure. Learn more of this with the austin .net developer.

DataAdapter: A bridge used to transfer data between a data source and a DataSet object. Learn more of this with the austin .net developer.

DataReader: Used to efficiently process a large list of results one record at a time. It allows records to be accessed in a read-only, forward-only mode, i.e., records have to be accessed in sequential order; they can neither be randomly accessed nor can a record which has been processed previously be accessed again.

DataSets objects, a group of classes describing a simple in-memory relational database, were the star of the show in the initial release (1.0) of the Microsoft .NET Framework. A DataSet is populated from a database by a DataAdapter whose Connection and Command properties have been set.

However, a DataSet can save its contents to XML, or populate itself from XML, making it exceptionally useful for web services, distributed computing, and occasionally-connected applications. For more information about ADO.NET and the .NET Framework, then visit the austin .net developer for details.

www.astonishdesigns.com

Article source: Expert Articles

Most Recent Articles in Programming category

  • ASP.NET development Benefits - By: Roshan K
    Rightwaysolution is a leading web development company offers ASP.NET website development, ASP.NET software development, ASP.NET programming services world wide through skilled ASP.NET developer.
  • Find a .net developer - By: Harjinder Kaur
    Find a .net developerFinding a .NET developer can be difficult. It is hard to find someone who is professional with hands-on experience. Today's technology is complex and requires a thorough understanding of business processes, infrastructure and needs. There can be a long learning curve when starting a new c#.net development project. How can a business find the right developer without spending a fortune or wasting time with unqualified candidates? Finding a senior net developer can be made easier when you use an outside consultant firm. That way, your company can find a well qualified developer with skills in c#, visual studio and the .net framework.
  • Why More People Today Are Turning To Notebooks Besides Their PC? - By: Jasveen Sidhu
    Computers have become a huge part of most people's lives. E-mail has become an easier and faster way of communication, and the Internet is a great way to get needed information. The computer may be used for anything from you needing it for work, all the way to your kids needing it for school.
  • Clean Your Computer With Cleaning Products - By: Ruby Persit
    Computer is a very common device nowadays. Computers are no more an appliance that is used in offices but it is becoming a part of our study room in home also. It is a mechanical gadget that finds its use in every aspect in every ones life. Most of the ladies are very particular in keeping their rooms clean.
  • The ADO.NET of the .NET Framework - By: Christine Layug
    ADO.NET is sometimes considered an evolution of ActiveX Data Objects (ADO) technology, but was changed so extensively that it can be conceived of as an entirely new product.
  • Flex Web Development Company India - By: Roshan K
    Adobe Flex is a collection of technologies released by Adobe Systems for the development and deployment of cross platform, rich Internet applications based on the proprietary Adobe Flash platform.
  • Surviving In a Technologically Demanding Business World - By: Scott Jarvis
    Of course those who do automate quickly learn that this does not necessitate the end of employing an IT staff. What it does mean however is that those individuals who once spent their days watching for and patching bugs can now be assigned more significant tasks which ultimately makes an IT department more productive. This also allows an IT budget to be neatly trimmed as the need for hours of overtime will be lessen considerably.
  • Why Data Center Automation? - By: Scott Jarvis
    IT managers or those hoping to secure such a prestigious position should be realize early on that automating their networks in part or in whole will not only free up resources and allow their teams to be more productive but will also create some free time for themselves as well. Things like Runbook automation and good ITIL management and mechanization will also free an IT manager from performing some of the more daunting and tedious tasks that a network demands before it becomes automated.
  • Ruby on rails - A Powerful Web Development Frame Work - By: Roshan K
    Ruby on Rail is a free web application framework, which intends to increase the speed and straightforwardness with which database-driven web sites can be created and offers skeleton code frameworks from the outset.
  • Asynchronous JavaScript and XML - Technology to Increase Website Interactivity! - By: John Wircken
    AJAX is known as Asynchronous JavaScript and XML. Ajax is a type of web development method popularized by Google.