Hitchhikers Guide to Visual Studio and SQL Server: Best Practice Architectures and Examples, 7th Edition (Microsoft Windows Server System Series)

They told you it couldn't be done. They were wrong. Yes, you can create and manage your own server-side, fully scrollable and updatable cursors on T-SQL Serverand you can do it all with ADO.NET. This appendix is excerpted from a popular magazine appendix that focused on missing functionality in the then-current version of ADO.NET. Since then, the problem of missing server-side cursors has not been fixedand it probably won't be. For a litany of reasons, Microsoft chose not to implement any server-side cursor functionality in any version of ADO.NET. This appendix discusses how you can work around this limitation to create and manage your own server-side cursors by using T-SQL ANSI T-SQL statements. Yes, this a lot more trouble than using ADO classic's (default) server-side cursor, but at least it's one viable (albeit a bit unusual) way to solve this problem.