datareader - connected or disconnected ^_^

[Fred]

hi,
some time ago in "the dot net show" i heard that microsoft has found no
usages for connected data access and all ado.net is disconnected; on the
other hand many ppl belive data readers keep open connection to the database

so i`m just curios wats the truth

 

[Marina]

I am sure you misinterpreted what was said. No one would every say that
connected data access is completely useless in all circumstances or that
microsoft dropped support for it.

Data readers are connected to the database. This is not a 'belief' - this
is well documented in the .NET framework documentation. Have you looked
there?

Excerpt from the SqlDataReader section:
While the SqlDataReader is in use, the associated SqlConnection is busy
serving the SqlDataReader, and no other operations can be performed on the
SqlConnection other than closing it.

This would also be very easy to test - shut down your database server while
you are looping through a data reader and see what happens. Or check the
connection's state while reading data from a datareader.

 

[Sahil Malik [MVP C#]]

Connected Data Access is just as important as Disconnected - so I find it
hard to beleive that MSFT has completely written off connected data access.
Can you point me to a link where I can listen to this claim?

- Sahil Malik [MVP]
ADO.NET 2.0 book -
http://codebetter.com/blogs/sahil.malik/archive/2005/05/13/63199.aspx

 

[Fred]

I am sure you misinterpreted what was said. No one would every say that
connected data access is completely useless in all circumstances or that
microsoft dropped support for it.

Data readers are connected to the database. This is not a 'belief' - this
is well documented in the .NET framework documentation. Have you looked
there?

Excerpt from the SqlDataReader section:
While the SqlDataReader is in use, the associated SqlConnection is busy
serving the SqlDataReader, and no other operations can be performed on the
SqlConnection other than closing it.

This would also be very easy to test - shut down your database server while
you are looping through a data reader and see what happens. Or check the
connection's state while reading data from a datareader.

i do believe u ^_^

 

[Fred]

Connected Data Access is just as important as Disconnected - so I find it
hard to beleive that MSFT has completely written off connected data access.
Can you point me to a link where I can listen to this claim?

- Sahil Malik [MVP]
ADO.NET 2.0 book -
http://codebetter.com/blogs/sahil.malik/archive/2005/05/13/63199.aspx

i`m not a 100% sure, i think it was either 17 episod
http://www.microsoft.com/downloads/...FamilyID=48853EEB-44D9-4B14-9824-397594B8FADC
or 13

 

[Cor Ligthert [MVP]]

Fred,

Connected data and disconnected data is the way as the data is handled.

Not the way as it is retrieved. To get data there will always be a kind of
connection, therefore the datareader is just a connected way of getting
data.

Internet, PDA's or whatever non connected device makes it impossible to
handle the data connected to the DataBase server as it was done with a
windowsform.

Beside that are millions connected handled tables (recordsets) probably to
much for any database server, while in the disconnected way it means only a
slower handling of the messages that it gets to handle the
retrieving/updating of the data.

I hope this helps,

Cor