1 / 18

Module 4

Module 4. Introduction ADO.NET. Objective. Explain the role of ADO.NET Describe data access architecture in .NET Differentiate between DAO, RDO, ADO and ADO.NET List the benefits of ADO.NET 2.0 Describe the disconnected data access approach. What is Database ?.

bertha-mcneil
Download Presentation

Module 4

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. Module 4 Introduction ADO.NET

  2. Objective • Explain the role of ADO.NET • Describe data access architecture in .NET • Differentiate between DAO, RDO, ADO and ADO.NET • List the benefits of ADO.NET 2.0 • Describe the disconnected data access approach

  3. What is Database ? • Database is a collection of related records. • The information in DB is stored in such a way that it is easier to access, manage, and update the data. • Data from the DB can be accessed using any one of the following architectures: • Single-tier architecture • Two-tier architecture • Three-tier architecture

  4. ADO.NET • Is the data access technology,which allows to access data from various data sources. • Is a part of .NET Framework: • The technology can be used for all .NET-base applications. • Supports disconnected data architecture: • Connection to the data source is established only required. • Use XML to interact with the DB: • All the data in the DB is converted into XML format for DB related operations.

  5. ADO.NET Features • Asynchronous processing: • Enable time-consuming application running in the background. • Multiple Active Result Sets (MARS): • Allow to execute multiple batches in a connection. • XML Data support • Bulk copy operations: • Allow to copy large files into tables or views • Batch processing • Tracing: • Monitor the excution of code  identify problems when executing code and fix them. • Connection pooling control: • Collects all the opened DB connections in a connection pool. • Get a connection from the pool for client rather than create new one.

  6. Data Access Architecture • The two important components of ADO.NET used for processing the data in DB are: • Data providers: • Provide and maintain connection to the DB • Dataset : • Is the required portion in database that is extracted and maintained in the form of a table as a local copy in the client system.

  7. Data Access Models

  8. Benefits of ADO.NET • Simplified Programming Model • Interoperability: • XML is the default format used for transmitting datasets across network, any component can read XML format is able to process data. • Maintainability • Programmability • Performance • Does not require data-type conversion while transmitting data through the tier. • Scalability

  9. Data Access Models of ADO.NET • Connected data access: • Connection to the DB is established when requested by an application. • This connection is kept open till the application is closed. • Disconnected data access: • Connection to the DB is established when the application forwards a request. • Once the request is processed, connection is automatically closed.

  10. Data Access Components • ADO.NET provides two components to access and manipulate data: • .NET Framework data provider • The DataSet • The objects associated withADO.NET technology are: • Command • Connection • DataAdapter • DataReader • DataSet • DataProvider

  11. Data Provider • Used for providing and maintaining connection to the database • Allows to perform different operations in the database: • .NET Framework Data Provider for SQL Server • .NET Framework Data Provider for OLE DB • .NET Framework Data Provider for ODBC • .NET Framework Data Provider for Oracle

  12. DataSet • Used to display and update data. • Used for retrieving data from multiple sources. • Can perform extensive processing on the data without having openconnection to the server.

  13. Connection • Allows to create a connection between application & DB. • In ADO.NET, a connection to SQL Server and OLE DB data source is established using the following connection class: • SqlConnection • OleDbConnection string strConnect = “server=(local);database=pubs;uid=sa;pwd=sa”; SqlConnection con = new SqlConnection(strConnect);

  14. Command • Enable to execute a command against a data source: • Make a call to a stored procedure • Execute SQL statements: INSERT, DELETE, UPDATE and SELECT • Is specific to the data provider used in a connection: • SqlComand: • Specifies the types of operation performed with the SQL Server. • OleDbCommand: • Specifies statements, stored procedures performed with any data source by using OLE DB provider.

  15. DataAdapter • A bridge between a DataSet and a DataSource: • Fill() method: fill DataSet from DataSource • Update() method: INSERT,UPDATE or DELETE data from data source • There are many kinds of DataAdapter: • OleDbDataAdapter • SqlDataAdapter • OdbcDataAdapter • OracleDataAdapter

  16. DataReader • Reads a stream of data from the DB. • Provides a forward-only, read-only stream of data : • Increases the application performace. • However, the DataReader object requires an exclusive use of an open connection object fot its whole life span. • SqlDataReader reader = commandObj . ExecuteReader();

  17. Summary • ADO.NET is a data access technology – supports disconnected data architecture • A data provider establishes and maintains connection to the database. The .NET Framework provides various data providers which are used for SQL Server, OLE DB, ODBC, Oracle data sources. • .NET Framework Data Providers and Dataset are used for accessing data source and then storing the retrieved records into tables : Connection, Command, DataAdapter, DataReader

More Related