|
dev
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
datareader - connected or disconnected ^_^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 :) 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. Show quote "Fred" <fred@ilovespam.com> wrote in message news:u$rOnyfHGHA.2036@TK2MSFTNGP14.phx.gbl... > 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 wrote:
Show quote > I am sure you misinterpreted what was said. No one would every say that i do believe u ^_^> 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. > > "Fred" <fred@ilovespam.com> wrote in message > news:u$rOnyfHGHA.2036@TK2MSFTNGP14.phx.gbl... > >>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 :) > > > 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 ---------------------------------------------------------------------------- Show quote "Fred" <fred@ilovespam.com> wrote in message news:u$rOnyfHGHA.2036@TK2MSFTNGP14.phx.gbl... > 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 :) Sahil Malik [MVP C#] wrote:
Show quote > Connected Data Access is just as important as Disconnected - so I find it i`m not a 100% sure, i think it was either 17 episod> 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" <fred@ilovespam.com> wrote in message > news:u$rOnyfHGHA.2036@TK2MSFTNGP14.phx.gbl... > >>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 :) > > > http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=48853EEB-44D9-4B14-9824-397594B8FADC or 13 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 Show quote "Fred" <fred@ilovespam.com> schreef in bericht news:u$rOnyfHGHA.2036@TK2MSFTNGP14.phx.gbl... > 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 :)  
Other interesting topics
|
|||||||||||||||||||||||
