SqlCeResultSet, why not in ADO.NET?

[Rick Lederman]

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

 

[KimKman]

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?

 

[Sahil Malik [MVP C#]]

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]

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