FACTOID # 8: Bookworms: Vermont has the highest number of high school teachers per capita and third highest number of librarians per capita.
 
 Home   Encyclopedia   Statistics   States A-Z   Flags   Maps   FAQ   About 
   
 
WHAT'S NEW
 

SEARCH ALL

FACTS & STATISTICS    Advanced view

Search encyclopedia, statistics and forums:

 

 

(* = Graphable)

 

 


Encyclopedia > ADO.NET

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 perceived as an entirely new product. This article or section does not adequately cite its references or sources. ... A database management system (DBMS) is a computer program (or more typically, a suite of them) designed to manage a database, a large set of structured data, and run operations on the data requested by numerous users. ... Microsoft ADO (ActiveX Data Objects) is a Component object model object for accessing data sources. ...

Contents

Image File history File links Download high resolution version (568x690, 29 KB). ... Image File history File links Download high resolution version (568x690, 29 KB). ... By the mid 20th century humans had achieved a mastery of technology sufficient to leave the surface of the Earth for the first time and explore space. ... .NET Framework 3. ...

Architecture

ADO.NET consists of two primary parts:


Data provider

These classes provide access to a data source, such as a Microsoft SQL Server or Oracle database. Each data source has its own set of provider objects, but they each have a common set of utility classes: Microsoft SQL Server is a relational database management system (RDBMS) produced by Microsoft. ... An Oracle database consists of a collection of data managed by an Oracle database management system. ...

  • 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.
  • DataAdapter: A bridge used to transfer data between a data source and a DataSet object (see below).
  • DataReader: A class used to efficiently process a large list of results one record at a time.

A Database Connection is the method in computer science that allows client software to talk to database server software, whether these exist on the same machine or not. ... A software design pattern, the Abstract Factory Pattern provides a way to encapsulate a group of individual factories that have a common theme. ... Command has multiple meanings: An order. ... The factual accuracy of this article is disputed. ... In ADO.NET, a DataReader object is used to sequentially read data from a data source of any kind. ...

DataSets

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. The classes form a containment hierarchy: A relational database is a database that conforms to the relational model, and refers to a databases data and schema (the databases structure of how that data is arranged). ... Microsoft is one of few companies engaging itself in the console wars Where they are up against sony, nintendo, and of course sharps new console which may cause a threat. ... This article or section does not adequately cite its references or sources. ...

  • A DataSet object represents a schema (either an entire database or a subset of one). It can contain tables and relationships between those tables.
    • A DataTable applications.

A Logical schema is a data model of a specific problem domain that has more detail than a conceptual schema, but does not include the design considerations and physical storage parameters found in a physical schema. ...

ADO.NET and Visual Studio.NET

Functionality exists in the Visual Studio .NET IDE to create specialized subclasses of the DataSet classes for a particular database schema, allowing convenient access to each field through strongly-typed properties. This helps catch more programming errors at compile-time and makes the IDE's Intellisense feature more useful. The Visual Studio . ... Screenshot of IntelliSense in Visual C++ IntelliSenseâ„¢ is a feature popularized by the Microsoft Visual Studio Integrated Development Environment. ...


ADO Vs. ADO.NET

A useful discussion of the shift from ADO to ADO.NET may be found in the MSDN article ADO.NET for the ADO Programmer. The Microsoft Developer Network (MSDN) is the portion of Microsoft responsible for managing the firms relationship with developers. ...


Entity Framework

The Entity Framework is a set of data access APIs for the Microsoft .NET Framework, to be included with a future version of ADO.NET. An Entity Framework Entity is an object which has a key representing the primary key of a logical datastore entity. A conceptual Entity Data Model (Entity-relationship model) is mapped to a datastore schema model. Using the Entity Data Model, the Entity Framework allows data to be treated as entities independently of their underlying datastore representations. A application programming interface (API) is the interface that a computer system, library or application provides in order to allow requests for services to be made of it by other computer programs, and/or to allow data to be exchanged between them. ... Microsoft is one of few companies engaging itself in the console wars Where they are up against sony, nintendo, and of course sharps new console which may cause a threat. ... This article or section does not adequately cite its references or sources. ... Databases are used to store structured data. ...


Entity SQL is a SQL-like language for querying the Entity Data Model (instead of the underlying datastore). Similarly, Linq extension Linq-to-Entities provides typed querying on the Entity Data Model. Entity SQL and Linq-to-Entities queries are converted internally into a Canonical Query Tree which is then converted into a query understandable to the underlying datastore (e.g. into SQL in the case of a Relational database). The entities can be modified, navigatated using their relationships, and their changes committed back to the datastore. SQL (commonly expanded to Structured Query Language — see History for the terms derivation) is the most popular computer language used to create, retrieve, update and delete (see also: CRUD) data from relational database management systems. ... Language intergrated query (LINQ) is a Microsoft project that aims to add a native querying syntax to C# and VB.Net. ... SQL (commonly expanded to Structured Query Language — see History for the terms derivation) is the most popular computer language used to create, retrieve, update and delete (see also: CRUD) data from relational database management systems. ... A relational database is a database that conforms to the relational model, and refers to a databases data and schema (the databases structure of how that data is arranged). ...


See also

A relational database management system (RDBMS) is a database management system (DBMS) that is based on the relational model as introduced by Edgar F. Codd. ... Microsoft ADO (ActiveX Data Objects) is a Component object model object for accessing data sources. ... In computing, Open Database Connectivity (ODBC) provides a standard software API method for using database management systems (DBMS). ... OLE DB (sometimes written as OLEDB or OLE-DB), Object Linking and Embedding for Databases, is a means Microsoft use for accessing different types of data stores in a uniform manner. ... The Extensible Markup Language (XML) is a W3C-recommended general-purpose markup language that supports a wide variety of applications. ...

External links


 
 

COMMENTARY     


Share your thoughts, questions and commentary here
Your name
Your comments

Want to know more?
Search encyclopedia, statistics and forums:

 


Press Releases |  Feeds | Contact
The Wikipedia article included on this page is licensed under the GFDL.
Images may be subject to relevant owners' copyright.
All other elements are (c) copyright NationMaster.com 2003-5. All Rights Reserved.
Usage implies agreement with terms, 1022, m