|
dev
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
SqlCeResultSet, why not in ADO.NET?I just discovered the SqlCeResultSet in the compact framework. It is more
like ADO or DAO than anything else that I have seen as far as coding in a VB application goes. It appears to be very fast and efficient too! Is there any plan to place the resultset in ADO.NET? It just seems FAR easier to implement with fewer lines of code than creating a dataset. Rick Lederman www.soaringsoftware.com When I need some fast simple db action on a website I mostly use classic
asp. Sometimes I feel bad about doing so but it is just so simple! Anyway have to tried using ArrayList or Generics? Show quote "Rick Lederman" <r***@soaringsoftware.com> wrote in message news:O3GswKiDGHA.2300@TK2MSFTNGP15.phx.gbl... >I just discovered the SqlCeResultSet in the compact framework. It is more >like ADO or DAO than anything else that I have seen as far as coding in a >VB application goes. It appears to be very fast and efficient too! Is >there any plan to place the resultset in ADO.NET? It just seems FAR easier >to implement with fewer lines of code than creating a dataset. > > Rick Lederman > www.soaringsoftware.com > Rick,
Okay here is my opinion - just my views. I think MS *may* have taken this out because if you had a forward/backward updateable cursor, such as SqlCeResultset - that would encourage a bad programming model. This is not such a problem for Compact frameworks, because typically you have a low power db, serving a single user. So it suits CF, but not DF (desktop framework). - Sahil Malik [MVP] ADO.NET 2.0 book - http://codebetter.com/blogs/sahil.malik/archive/2005/05/13/63199.aspx __________________________________________________________ Show quote "Rick Lederman" <r***@soaringsoftware.com> wrote in message news:O3GswKiDGHA.2300@TK2MSFTNGP15.phx.gbl... >I just discovered the SqlCeResultSet in the compact framework. It is more >like ADO or DAO than anything else that I have seen as far as coding in a >VB application goes. It appears to be very fast and efficient too! Is >there any plan to place the resultset in ADO.NET? It just seems FAR easier >to implement with fewer lines of code than creating a dataset. > > Rick Lederman > www.soaringsoftware.com > Sahil,
Thanks for your opinion, and it makes sense. I'm getting more comfortable with the data adapter and data set now. For the moment I'm using that in the pocket application. It took a while to figure much of it out as way too many of the examples simply don't do things like my application does. Rick Show quote "Sahil Malik [MVP C#]" <contactmethrumyblog@nospam.com> wrote in message news:uMLG27xDGHA.4072@TK2MSFTNGP10.phx.gbl... > Rick, > > Okay here is my opinion - just my views. > > I think MS *may* have taken this out because if you had a forward/backward > updateable cursor, such as SqlCeResultset - that would encourage a bad > programming model. This is not such a problem for Compact frameworks, > because typically you have a low power db, serving a single user. So it > suits CF, but not DF (desktop framework). > > - Sahil Malik [MVP] > ADO.NET 2.0 book - > http://codebetter.com/blogs/sahil.malik/archive/2005/05/13/63199.aspx > __________________________________________________________ > > > "Rick Lederman" <r***@soaringsoftware.com> wrote in message > news:O3GswKiDGHA.2300@TK2MSFTNGP15.phx.gbl... >>I just discovered the SqlCeResultSet in the compact framework. It is more >>like ADO or DAO than anything else that I have seen as far as coding in a >>VB application goes. It appears to be very fast and efficient too! Is >>there any plan to place the resultset in ADO.NET? It just seems FAR >>easier to implement with fewer lines of code than creating a dataset. >> >> Rick Lederman >> www.soaringsoftware.com >> > >  |
|||||||||||||||||||||||
Other interesting topics