ADO.NET Core
Basics of ADO.NET
Basics of ADO.NET
  • Concepts
    • Database tools overview
      • SSMS & VS Data tools
    • ADO.NET Basics
  • Code
    • Connected mode
      • Create the database
      • Create project
      • Read data
      • Insert data
    • Disconnected mode
      • Create project
      • Read data
      • Insert data
    • GitHub Repo
  • Optional
    • WinForms walkthrough MS
    • Northwind DB
Powered by GitBook
On this page
  1. Code

Disconnected mode

Disconnected mode

In disconnected mode, the application connects to a database, retrieves the required data, and then disconnects from the database. Once the data has been retrieved, the application can work with the data offline without keeping a continuous connection to the database. In this mode, the database is accessed only when necessary, which can help reduce network traffic and improve application performance.

In ADO.NET, the "disconnected mode" refers to a data access model where a connection to a data source is opened, data is retrieved from the data source, and then the connection is closed immediately. The data is then held in a disconnected state in a dataset or data table object.

Let us discuss how to create and read a database in disconnected mode using ADO.NET

PreviousInsert dataNextCreate project

Last updated 2 years ago