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

KimKman
Sat Dec 31 16:10:54 CST 2005

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 Lederman" <rick@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
Sun Jan 01 16:01:54 CST 2006

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" <rick@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
Mon Jan 02 14:51:39 CST 2006

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


"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" <rick@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
>>
>
>