Connected & Disconnected architecture differences in ADO.NET

Question

1.00/5 (1 vote)

See more:

I know this question has been asked multiple times.. But I m little confused with all the diff answers i found in web.

Why connected architecture is called connected architecture in ADO.NET ?

Why disconnected architecture is called disconnected architecture in ADO.NET ?

I know, Connected means read-only, forward-only etc... and disconnected means you can work offline with data.

But my questions are -

1. Is there any difference in # of hits to database?
2. In both cases, when the connection to DB is opened and closed?
3. Why do we have to use Connection.Close() in disconnected architecture when it gets the data and disconnects the connection?Am i getting confused b/w Close & Disconnect?

Please help me in clarifying these doubts... I just want to go in and see what's happening exactly.

Thank you.

Posted 1-Feb-15 19:54pm

bpc1989

Updated 10-Sep-18 3:59am

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Nilendra Nath · Accepted Answer · 2015-02-02T00:02:00

1. There is no difference in # of hits, as no of hits depends upon how you have coded your program, its not about what type of connection you are using.
But somewhere in disconnected mode you can manage less # of hits for each db connection made.
2. Its true that in both cases DB is opened and closed, but in connected environment user occupy the connection until he finishes all his queries which slow down the network, in disconnected you fetch the data and close the connection so its free for other users.
3. When you request to open a connection with db server, your connection get opened and an entry is made in connection pool, until you will not close the connection, it remains open in pool, so to free the source you need to close it. Disconnect is not closing the connection.