ASP.NET and ADO.NET

You might have noticed that a significant portion of new technology is considered stateless or connectionless. For example, GDI+ is stateless, meaning you have to pass in font, color, brush, and pen information each time you interact with a GDI+ device context.

ADO.NET is connectionless. What this means to you is that you do not have a live cursor when you get data from a database using ADO.NET. In fact, the DataSet component actually grabs a copy of the data and caches it locally. This means that you will want to reconsider those SELECT * FROM tablename queries and be more circumspect about how and what you request. On a positive note, working with ADO.NET is easier than ADO, and data-enabling an ASP.NET Web application is ...

Get Visual Basic® .NET Unleashed now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.