Visual Basic 2015 Unleashed

Connection Modes

ADO.NET provides support for both connected and disconnected modes. The big difference between the two modes is that in a connected mode, you explicitly open and close connections against a data source so that you can work with data. This is something you accomplish with the Connection, DataReader, and Command objects. In a disconnected environment, you work against in-memory data that is later persisted to the underlying data source. This is achieved with DataSets, although you see starting from Chapter 24, “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 difference between ...