SqlCeResultSet, why not in ADO.NET?

  • Thread starter Thread starter Rick Lederman
  • Start date Start date
R

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
 
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?
 
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
__________________________________________________________
 
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
 
Back
Top