connected vs disconnected techniuqes in ado.net

  • Thread starter Thread starter amro_ka
  • Start date Start date
A

amro_ka

hello all.
iam new here well ill say directly what i wanna know
what is the diffrance between connected and disconnected techniuques
in ado.net and when to use disconnected and when to use connected in
your application and if your application is gonna run on a LAN and you
have many instants of your application connecting to the same tables
and deal with it (insert,delete & update) which is better
connected or disconnected and plz give me examples on applications
that needs disconnected and applications that needs connected modes

Thanx alot

amro
 
It's actually pretty easy:

If you use a DataReader object to hold your data, you have connected access.
however this access is READ ONLY and only allows FORWARD movement through
resulting data.

All other data storage in ADO.NET is disconnected and allow for any kind of
changes and/or movement.


amro_ka said:
hello all.
iam new here well ill say directly what i wanna know
what is the diffrance between connected and disconnected techniuques
in ado.net and when to use disconnected and when to use connected in
your application and if your application is gonna run on a LAN and you
have many instants of your application connecting to the same tables
and deal with it (insert,delete & update) which is better
connected or disconnected and plz give me examples on applications
that needs disconnected and applications that needs connected modes

Thanx alot

amro
Click to expand...
 
thnx Scott M. for replying
but actually seems you didnt get what i mean
i mean what is the diffrance between the ado connected(like in vb 6
its exist in vs.net too and you can use it in .NET too) and ado.net
(which is the new one that microsoft included in vs.net) the only
diffrance i know is that in ado disconnected you query the data by
the adapter then u fill the dataset from the adapter and then close
the connection between the application and the db server and deal
with the data in the dataset then after you finish the work you
update from the dataset to the data base through the adapter too

and the connected ado you have an open connection between the
program and the server
i thinked in it but i dont know if iam right or not if my application
will work on a lan and i have many instants of my application
dealing with the same tables then i would use ado connected!

and if iam in a place that the cost of networking high (imagine a
client in the desert and a server in a town ) i would use
disconnected

******************************************************
if you know any other diffrances please mention it & i wanna
know
what kind of applications that needs disconnectd ado and what kind
needs connected ado?
******************************************************
 
Actually, I did get your meaning. Maybe you didn't get mine....

In .NET you can take advantage of the old "ADO" if you want, but the native
way to handle data connectivity is to use ADO .NET and in ADO .NET, you work
with disconnected data in all cases except for when you are using a
DataReader for forward only, read only data access. Everything else in .NET
is disconnected access.

I think you are trying too hard to figure out how to take the old ADO and
use it in .NET.


amro_ka said:
thnx Scott M. for replying
but actually seems you didnt get what i mean
i mean what is the diffrance between the ado connected(like in vb 6
its exist in vs.net too and you can use it in .NET too) and ado.net
(which is the new one that microsoft included in vs.net) the only
diffrance i know is that in ado disconnected you query the data by
the adapter then u fill the dataset from the adapter and then close
the connection between the application and the db server and deal
with the data in the dataset then after you finish the work you
update from the dataset to the data base through the adapter too

and the connected ado you have an open connection between the
program and the server
i thinked in it but i dont know if iam right or not if my application
will work on a lan and i have many instants of my application
dealing with the same tables then i would use ado connected!

and if iam in a place that the cost of networking high (imagine a
client in the desert and a server in a town ) i would use
disconnected

******************************************************
if you know any other diffrances please mention it & i wanna
know
what kind of applications that needs disconnectd ado and what kind
needs connected ado?
******************************************************
Click to expand...
 
Back
Top