Conclusion

Centered around the disconnected model, ADO.NET incorporates a made-to-measure API to let developers store and consume data through special in-memory containers with two key capabilities. First, they behave like real databases and provide interface and functions similar to those of a server DBMS. Second, they're serializable and implement a commit model for you to handle changes in an extremely flexible way.

Classes such as DataSet and DataTable are ideal to package data to be moved across the tiers of a distributed system. They offer advanced, database-like features such as referential integrity, optimistic locking, constraints, indexing, and filtering. They lend themselves to operate well in batch-update scenarios, where client code ...

Get Programming Microsoft® ASP.NET 3.5 now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.