Connection Modes
ADO.NET provides support for both connected and disconnected modes. The big difference between the two modes is that in a connected fashion you explicitly open and close connections against a data source so that you can work with data. This is something that you accomplish with Connection, DataReader and Command objects. In a disconnected environment you basically work against in-memory data that is later persisted to the underlying data source. Generally this is achieved with DataSets, although you see starting from Chapter 25, “LINQ to SQL,” how such an approach is the same in LINQ to ADO.NET. I’m sure that you already worked with both modes in your developer experience, so here’s just a quick recap so that you appreciate the ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access