Skip to content

Miniature desktop application for demonstrating the ADO.NET disconnected layer access to databases.

Notifications You must be signed in to change notification settings

cwelt/ADO.NET-Disconnected-Layer-Demonstration

Repository files navigation

ADO.NET-Disconnected-Layer-Demonstration 🔓

Miniature desktop application for demonstrating the ADO.NET disconnected layer access to databases.

Disconnected Layer Illustration

Brief Description

This application demonstrates the usage of data adapters, datasets, data tables
and the interaction between them, while constantly displaying the connection state (opened/closed),
with an option to display the row state that is maintained by the unit of work,
and serializing and deseriailzing the data & schema to/from XML and XSD files.

Database diagram

The appliaction uses the following database for demonstration: Database Diagram

General Background

The disconnected layer manipulates the data in-memory while keeping the connection to the database closed,
and openning the connection only to sync reads/writes,
conceptually implementing Martin Fowler's Record set pattern.
This pattern's idea is similar in it's concept to Git & GitHub workflow:

  • Pull (Clone/Fork) is similar to the data adapter's Fill method.
  • Push is similar to the data adapter's Update method.

Disconnected Layer Illustration

Releases

No releases published

Packages

No packages published

Languages