Re: ADO.NET 2.0 - ResultSet concerns

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Greg Low \(MVP\) (greglow_at_lowell.com.au)
Date: 04/13/04 

Date: Tue, 13 Apr 2004 15:20:36 +1000

Hi Angel,

I'd so like the SqlResultset object to not make it into the next release. It
will be the most misused feature ever. Most of the problems people had with
ADO was misuse of server-side cursors.

Regards, 

-- 
Greg Low (MVP)
MSDE Manager SQL Tools
www.whitebearconsulting.com
"Angel Saenz-Badillos[MS]" <angelsa@online.microsoft.com> wrote in message
news:%23Xyq8rLIEHA.3240@TK2MSFTNGP12.phx.gbl...
> William,
> I believe that you have been able to capture the soul of the argument in
> these posts, the short and the long of it is that there are some very
> specific problems that absolutely require a connected resultset (Some OLTP
> apps for example), this feature is also the cornerstone of a much more
> requested feature, Paging. However, using this feature when it is not
> required is disastrous for scalability and it is almost guaranteed that it
> will be miss-used, in fact, I cannot think of a good use of Paging at all.
> IMO used in asp.net pages it will slow down servers to a crawl. Another
good
> point is that, like you mentioned, adding this feature now is going to
> confuse the message that we have only now started to get through. The last
> point is that for the very rare app that requires server side cursors you
> can always use ado or create the cursor yourself with TSQL "declare c
CURSOR
> DYNAMIC for SELECT ..."
>
> Practically everybody that I have talked to about the v2.0 ado.net
features
> places this at the top of his concern list and we are looking very
carefully
> at these features. Thanks for bringing this up, I will forward your
comments
> appropriately.
> -- 
> Angel Saenz-Badillos [MS] Managed Providers
> This posting is provided "AS IS", with no warranties, and confers no
> rights.Please do not send email directly to this alias.
> This alias is for newsgroup purposes only.
>
>
> "William Ryan eMVP" <bill@NoSp4m.devbuzz.com> wrote in message
> news:OWKZXW9HEHA.3556@TK2MSFTNGP10.phx.gbl...
> > Hi Cor:
> >
> > I appreciate your opinion and just wanted to follow up.  I think we both
> > agree that progress is good and that you need to go forward.  If the
> > resultset was included from the beginning, I think it would be a LOT
less
> > confusing for newbies.  Maybe I'm just being a bit pessimistic in this
> > regard, but i foresee a ton of confusion b/c there's still a ton of
> > confusion and this will only blur the line.  I suspect that many ADO
> > programmers are going to rely on it exclusively and I just foresee some
> > confusion.  However, when I start sounding like a Chicken-Little, that's
a
> > good indicator that I need to quit philosophizing and start reading more
> > about a subject.
> >
> > Thanks again,
> >
> > Bill
> >
> > BTW, I responded to the DataReader Limitation post.  didn't mean to step
> on
> > any toes there ;-)
> > "Cor Ligthert" <notfirstname@planet.nl> wrote in message
> > news:eBubFf5HEHA.3968@TK2MSFTNGP12.phx.gbl...
> > > Hi Bill,
> > >
> > > History always repeats.
> > > When I started data processing, it was in the time of the punching
> cards.
> > > People where sorting them column by column, when you have to do a lot
of
> > > columns and a hugs amount of cards that is hard labour.
> > >
> > > There where also machines with which what you could do intelligent
> > sequence
> > > checking by making let say program boards (was with wires), took
> sometimes
> > > time how to do it, but when you did know how,  it was very easy to do
> (It
> > > was collecting the good sequences into the others while creating let
say
> > > streams again from the wrongs ones).
> > >
> > > I think you have seen messages enough from me to understand which way
I
> > > took. However, there where people in my environment who said I was
only
> > > lazy.
> > >
> > > Then we got magnetic tape, that method that I did was of course also
one
> > of
> > > the better methods to sort a tape. However, I did not like the
magnetic
> > > tape; I did like the disc and especially the disc that could read fast
> > > randomly.
> > >
> > > However, there where people who said using a random disc was not sure
> and
> > > not as fast as a magnetic tape and they did use the magnetic disc as a
> > tape.
> > > (Do understand me; there are problems, which still can be done the
best
> > way
> > > doing that.)
> > >
> > > I can go on of course, but what I want to say is that there are
> companies
> > > which have there biggest earnings from those people I tell you about.
> They
> > > still have environments build on the principles of the punch card or
> > > environments build on the time the students came in the computing
> > business.
> > >
> > > One of the things I have always like from Microsoft is that they did
not
> > > listen to those people who are stopping progression. I hope this will
be
> > the
> > > same in future.
> > >
> > > Just my thoughts about your message,
> > >
> > > Cor
> > >
> > >
> > >
> > >
> > >
> >
> >
>
>

Relevant Pages

  • Re: ADO.NET 2.0 - ResultSet concerns
    ... requested feature, Paging. ... > confusion and this will only blur the line. ... >> the better methods to sort a tape. ... I did like the disc and especially the disc that could read fast ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Application to monitor Battery (power or current) usage
    ... Sorry about the confusion - By all means it was not meant to be taken badly ... me another cool feature in a program I use every day. ... thanks for my audible alarms when the rest of the device is ... Terry ...
    (microsoft.public.pocketpc)
  • Re: ADO.NET 2.0 - ResultSet concerns
    ... We received this same feedback across the board. ... > will be the most misused feature ever. ... > ADO was misuse of server-side cursors. ... >>> confusion and this will only blur the line. ...
    (microsoft.public.dotnet.framework.adonet)
  • Merge documents - Word 2002
    ... My question refers ... to the "Compare and Merge documents" feature is Word ... Document Management System techs expect much confusion ...
    (microsoft.public.word.docmanagement)
  • Re: ADO.NET 2.0 - ResultSet concerns
    ... confusion and this will only blur the line. ... > Then we got magnetic tape, that method that I did was of course also one ... > the better methods to sort a tape. ... I did like the disc and especially the disc that could read fast ...
    (microsoft.public.dotnet.framework.adonet)