Transcript ADO.NET Powerpoint Presentation

ADO.NET
Database access in .NET style!
Question 1
ADO is an acronym for
A.
B.
C.
D.
Another Dang Object
Asynchronous Data Object
Active Disk Object
ActiveX Data Object
What is ADO
Microsoft ADO (ActiveX Data Objects) is a Component object model
object for accessing data sources. It provides a layer between
programming languages and OLE DB (a means of accessing data
stores, whether they be databases or otherwise, in a uniform
manner), which allows a developer to write programs which access
data, without knowing how the database is implemented. You must
be aware of your database for connection only. No knowledge of
SQL is required to access a database when using ADO, although
one can use ADO to execute arbitrary SQL commands. The
disadvantage of this is that this introduces a dependency upon the
database.
It is positioned as a successor to Microsoft's earlier object layers for
accessing data sources, including RDO (Remote Data Objects) and
DAO (Data Access Objects). ADO was introduced by Microsoft in the
winter of 1996.
- Wikipedia.org (http://en.wikipedia.org/wiki/ActiveX_Data_Objects)
What is ADO.NET
ADO.NET (or the new ActiveX Data Objects
technology) is the primary relational data access
model for Microsoft .NET-based applications. It
may be used to access data sources for which
there is a specific .NET Provider, or, via a .NET
Bridge Provider, for which there is a specific OLE
DB Provider, ODBC Driver, or JDBC Driver.
ADO.NET is sometimes considered an evolution of
ADO technology, but it is important to note that
some major changes were made between the two.
- Wikipedia.org (http://en.wikipedia.org/wiki/ADO.NET)
Question 2
A WIMP is
A.
B.
C.
D.
A person unwilling to take a stand on
an issue
Eric Brown in a previous life
A MS-Windows centric web application
model
Darl McBride, President and CEO, The
SCO Group
Where does it all belong?

AMP/WAMP/LAMP


WIMSA


Windows, IIS, MS-SQL, ASP/ADO
WIMP


{0,Windows,Linux}, Apache, MySQL, {PHP, Python, Perl}
Windows, IIS, MySQL, {PHP, Python, Perl}
Further proof that Computer
Scientists use way too many
acronyms!
The Big Picture
As true with any type of database
programming, web applications need
a middle layer to detach the
application from the database
 Some believe it is desirous to have an
all-encompassing object to handle
this middleware function
 Enter ADO.NET …

Question 3
Which of the following are the 2
primary components of the ADO
Object Model?
A.
B.
C.
D.
DataGrid
Data Provider
DataResultGrid
DataSet
ADO.NET Parts
From Programming ASP.NET, 3rd Edition By Dan Hurwitz, Jesse Liberty
http://proquest.safaribooksonline.com/059600916X/progaspdotnet3-CHP-10-SECT-1
DataSet Methods
Method
Type
AcceptChanges void
Description
Accepts all the changes made since loaded or since last time
AcceptChanges was called (see GetChanges).
Clear
void
Clears the dataset of any data.
GetChanges
DataSet Returns a copy of the dataset containing all the changes
made since loaded or since AcceptChanges was called.
GetXML
string Returns the XML representation of the data in the dataset.
GetXMLSchema string Returns the XSD schema for the XML representation of the
data in the dataset.
Merge
void
Merges the data in this dataset with another dataset.
Overloaded.
ReadXML
XmlReadModeReads an XML schema and data into the dataset.
Overloaded.
DataSet Methods (cont.)
Method
Type
ReadXMLSchema void
RejectChanges void
WriteXML
void
WriteXMLSchema void
Description
Reads an XML schema into the dataset.
Rolls back to the state since last AcceptChanges (see
AcceptChanges).
Writes out the XML schema and data from the dataset.
Overloaded.
Writes the structure of the dataset as an XML schema.
Overloaded.
Example Code
Questions

OK, if that is all of the questions, I
have some.
Quiz
1.
2.
3.
4.
ADO is an acronym for ?
A WIMP is ________________ ?
Name the 2 major components of
the ADO Object Model.
(True/False) An ADO object cannot
write XML representations.