Will ADO.NET 2.0 have a connected server-side cursor mode ??

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Stefano - 30 Jun 2004 16:18 GMT

Hi all,
certainly know the good-old ado recordset with the capability of have
a server side cursor with it advantages ad disadvantages.
In some roadshow during this year someone has tell to me that 2.0
version on ADO.NET we would have had the server-side cursor come back
again.
Is this true ??
TIA
Stefano

Reply to this Message

William Ryan eMVP - 30 Jun 2004 16:34 GMT

Sure does
http://www.awprofessional.com/bookstore/product.asp?isbn=0321228391&redir=1
(An excellent book by the way.) you can also hit the Express site at
Microsoft to get the newest versions of C# et al , plus the 2.0 framework
just became an official beta. I have links on my blog
www.msmvps.com/WilliamRyan but if you check out
http://labs.msdn.microsoft.com/Express you can grab each of them.

HTH,

Bill

Signature

W.G. Ryan, eMVP

Have an opinion on the effectiveness of Microsoft Embedded newsgroups?
Let Microsoft know!
https://www.windowsembeddedeval.com/community/newsgroups

> Hi all,
> certainly know the good-old ado recordset with the capability of have
[quoted text clipped - 5 lines]
> TIA
> Stefano

Reply to this Message

Stefano - 30 Jun 2004 17:24 GMT

Hmm,
are you sure ??
These were probably the "initial" specifications.
It contains objectspaces that has been dropped from VS2005 version.
By
Stefano

>Sure does
>http://www.awprofessional.com/bookstore/product.asp?isbn=0321228391&redir=1
[quoted text clipped - 7 lines]
>
>Bill

Reply to this Message

William Ryan eMVP - 30 Jun 2004 18:54 GMT

Being that it's a beta, I can't guarantee anything about it. ObjectSpaces
will be included but as a Feature pack in the 'near' future after the
original release. I was incorrect to state anything in the affirmative
about the original release b/c it could change, but as of last night, the
latest build had SqlResultSets in it.

Signature

W.G. Ryan, eMVP

Have an opinion on the effectiveness of Microsoft Embedded newsgroups?
Let Microsoft know!
https://www.windowsembeddedeval.com/community/newsgroups

> Hmm,
> are you sure ??
[quoted text clipped - 15 lines]
> >
> >Bill

Reply to this Message

William \(Bill\) Vaughn - 30 Jun 2004 18:39 GMT

Ah, no. "Server-side" cursors were dropped from ADO.NET 2.0 this spring.
There is still a way to create server-side cursors using ADO.NET. See my
"Doing the Impossible" article for Pinnacle (www.betav.com/articles.htm). It
discusses how to use the CREATE CURSOR TSQL commands to build and manage a
server-side cursor.

Signature

____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________

> Hi all,
> certainly know the good-old ado recordset with the capability of have
[quoted text clipped - 5 lines]
> TIA
> Stefano

Reply to this Message

Will ADO.NET 2.0 have a connected server-side cursor mode ??

Free Magazines