Appendix IV. Creating and Managing Server-Side Cursors

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.