Scribd Logo
Upload

Welcome to Scribd!

  • 76 views

    Connected Vs Disconnected

    Uploaded by

    sandysir
    ADO.NET addresses problems with previous data access methods by using a disconnected model that opens brief connections to serve requests and closes them immediately. This improves performance and security. It also converts data to XML format for more efficient database operations. ADO.NET relies on DataSet objects that cache relevant database data in memory independently, and Data Provider objects that maintain connections to the database and execute commands. Data access involves opening a connection, executing commands directly or via a DataReader or DataAdapter to populate a DataSet, then updating the database if needed before closing the connection.

    Copyright:

    © All Rights Reserved
    Download as DOC, PDF, TXT or read online from Scribd

    Connected Vs Disconnected

    Uploaded by

    sandysir
    76 views2 pages
    ADO.NET addresses problems with previous data access methods by using a disconnected model that opens brief connections to serve requests and closes them immediately. This improves performance and security. It also converts data to XML format for more efficient database operations. ADO.NET relies on DataSet objects that cache relevant database data in memory independently, and Data Provider objects that maintain connections to the database and execute commands. Data access involves opening a connection, executing commands directly or via a DataReader or DataAdapter to populate a DataSet, then updating the database if needed before closing the connection.

    Original Description:

    difference between Connected vs Disconnected in ado.net

    Original Title

    Connected vs Disconnected

    Copyright

    © © All Rights Reserved

    Available Formats

    DOC, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    ADO.NET addresses problems with previous data access methods by using a disconnected model that opens brief connections to serve requests and closes them immediately. This improves performance and security. It also converts data to XML format for more efficient database operations. ADO.NET relies on DataSet objects that cache relevant database data in memory independently, and Data Provider objects that maintain connections to the database and execute commands. Data access involves opening a connection, executing commands directly or via a DataReader or DataAdapter to populate a DataSet, then updating the database if needed before closing the connection.

    Copyright:

    © All Rights Reserved
    Download as DOC, PDF, TXT or read online from Scribd
    Download as doc, pdf, or txt
    76 views2 pages

    Connected Vs Disconnected

    Uploaded by

    sandysir
    ADO.NET addresses problems with previous data access methods by using a disconnected model that opens brief connections to serve requests and closes them immediately. This improves performance and security. It also converts data to XML format for more efficient database operations. ADO.NET relies on DataSet objects that cache relevant database data in memory independently, and Data Provider objects that maintain connections to the database and execute commands. Data access involves opening a connection, executing commands directly or via a DataReader or DataAdapter to populate a DataSet, then updating the database if needed before closing the connection.

    Copyright:

    © All Rights Reserved
    Download as DOC, PDF, TXT or read online from Scribd
    Download as doc, pdf, or txt
    You are on page 1of 2

    Why ADO.NET?

    To cope up with some of the problems mentioned above, ADO .NET came into
    existence. ADO .NET addresses the above mentioned problems by maintaining a
    disconnected database access model which means, when an application
    interacts with the database, the connection is opened to serve the request of the
    application and is closed as soon as the request is completed. Likewise, if a
    database is Updated, the connection is opened long enough to complete the
    Update operation and is closed. By keeping connections open for only a
    minimum period of time, ADO .NET conserves system resources and provides
    maximum security for databases and also has less impact on system
    performance. Also, ADO .NET when interacting with the database uses XML and
    converts all the data into XML format for database related operations making
    them more efficient.

    The ADO.NET Data Architecture

    Data Access in ADO.NET relies on two components: DataSet and Data Provider.

    DataSet

    The dataset is a disconnected, in-memory representation of data. It can be


    considered as a local copy of the relevant portions of the database. The DataSet
    is persisted in memory and the data in it can be manipulated and updated
    independent of the database. When the use of this DataSet is finished, changes
    can be made back to the central database for updating. The data in DataSet can
    be loaded from any valid data source like Microsoft SQL server database, an
    Oracle database or from a Microsoft Access database.

    Data Provider

    The Data Provider is responsible for providing and maintaining the connection to
    the database. A DataProvider is a set of related components that work together
    to provide data in an efficient and performance driven manner. The .NET
    Framework currently comes with two DataProviders: the SQL Data Provider
    which is designed only to work with Microsoft's SQL Server 7.0 or later and the
    OleDb DataProvider which allows us to connect to other types of databases like
    Access and Oracle. Each DataProvider consists of the following component
    classes:

    The Connection object which provides a connection to the database


    The Command object which is used to execute a command
    The DataReader object which provides a forward-only, read only, connected
    recordset
    The DataAdapter object which populates a disconnected DataSet with data and
    performs update

    Data access with ADO.NET can be summarized as follows:

    A connection object establishes the connection for the application with the
    database. The command object provides direct execution of the command to the
    database. If the command returns more than a single value, the command object
    returns a DataReader to provide the data. Alternatively, the DataAdapter can be
    used to fill the Dataset object. The database can be updated using the command
    object or the DataAdapter.

    You might also like