1 / 14

ADO.NET

ADO.NET. Database access in .NET style!. Question 1. ADO is an acronym for Another Dang Object Asynchronous Data Object Active Disk Object ActiveX Data Object. What is ADO.

orlando-conley
Download Presentation

ADO.NET

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. ADO.NET Database access in .NET style!

  2. Question 1 ADO is an acronym for • Another Dang Object • Asynchronous Data Object • Active Disk Object • ActiveX Data Object

  3. 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)

  4. 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)

  5. Question 2 A WIMP is • 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

  6. Where does it all belong? • AMP/WAMP/LAMP • {0,Windows,Linux}, Apache, MySQL, {PHP, Python, Perl} • WIMSA • Windows, IIS, MS-SQL, ASP/ADO • WIMP • Windows, IIS, MySQL, {PHP, Python, Perl} • Further proof that Computer Scientists use way too many acronyms!

  7. 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 …

  8. Question 3 Which of the following are the 2 primary components of the ADO Object Model? • DataGrid • Data Provider • DataResultGrid • DataSet

  9. ADO.NET Parts From Programming ASP.NET, 3rd Edition By Dan Hurwitz, Jesse Liberty http://proquest.safaribooksonline.com/059600916X/progaspdotnet3-CHP-10-SECT-1

  10. DataSet Methods Method Type Description AcceptChanges void 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.

  11. DataSet Methods (cont.) Method Type Description ReadXMLSchema void Reads an XML schema into the dataset. RejectChanges void Rolls back to the state since last AcceptChanges (see AcceptChanges). WriteXML void Writes out the XML schema and data from the dataset. Overloaded. WriteXMLSchema void Writes the structure of the dataset as an XML schema. Overloaded.

  12. Example Code

  13. Questions • OK, if that is all of the questions, I have some.

  14. Quiz • 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.

More Related