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

[Stefano]

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

 

[William Ryan eMVP]

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


--

W.G. Ryan, eMVP

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

 

[Stefano]

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

 

[William \(Bill\) Vaughn]

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.

--
____________________________________
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.
__________________________________

 

[William Ryan eMVP]

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.

--

W.G. Ryan, eMVP

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