Wrox Programmer Forums
ADO.NET For discussion about ADO.NET.  Topics such as question regarding the System.Data namespace are appropriate.  Questions specific to a particular application should be posted in a forum specific to the application .
Welcome to the p2p.wrox.com Forums.

You are currently viewing the ADO.NET section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old September 14th, 2006, 03:12 PM
Registered User
Join Date: Aug 2006
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default difference

Hi all,
What is the difference between connected and disconnected connections?How do they operate?

Best Regards

Old September 19th, 2006, 07:02 PM
Friend of Wrox
Join Date: Jun 2003
Posts: 1,093
Thanks: 1
Thanked 12 Times in 11 Posts

Basically, the ADO.NET object model contains two types of objects: Connected objects (like Connection, Transaction, DataAdapter, Command, Parameter, and DataReader) and Disconnected objects (like DataSet, DataTable, DataView, DataRow, DataColumn, Constraint, and DataRelation).

Connected objects talk directly to and require (or manage) a live connection to your data source, and connected objects that can retrieve or modify data can only do so in a forward-only, read-only stream (you can’t sort, search, filter, etc.) query results with connected objects in .NET

Disconnected objects don’t require a live connection to your data source. They allow you to close the connection to your data source and continue to work with data in an off-line data cache.



Similar Threads
Thread Thread Starter Forum Replies Last Post
Difference between name(*) and name() vikkiefd XSLT 3 March 11th, 2008 06:40 AM
Difference ashu .NET Framework 1.x 1 March 27th, 2007 09:46 AM
difference Magen Classic ASP Basics 2 January 29th, 2007 04:48 PM
what's the difference? jdkxxx Oracle 3 October 8th, 2005 12:33 PM
The difference mhergenrader J2EE 1 July 15th, 2005 07:20 AM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.