SQL Server 2005 Omissions

I've been digging deep into SQL Server 2005's CLR integration over the last few days.  I am surprised by several specific omissions.  My guess is that they have been dropped because of time constraints:

  • Server-side cursor in Managed Code (SqlResultSet) is now missing and will probably be MIA in the release.
  • Good solution for translating a SqlDataReader's schema into SqlMetaData (which is used with SqlDataRecord to share schema with the client).
  • No access to current Transaction.  (Used to be part of the SqlContext, but now is missing).

In addition, the current release of the InProc Managed provider has made some interesting choices that are different from earlier version:

  • SqlContext no longer gives access to the current connection, but if you create a command object and execute it, it magically is done on the current connection.
  • No way to enlist a command to the current transaction.

Its going to be interesting to see where it goes from here.  All of these changes are only since the February CTP.  I can't imagine it's going to stop here...

Shawn Wildermuth
Author, Teacher, and Coach

My Courses

Wilder Minds Training
Vue.js by Example (New Lower Price)
Bootstrap 4 by Example (New Lower Price)
Intro to Font Awesome 5 (Free Course)
Building an API with ASP.NET Core (New Course)
Building a Web App with ASP.NET Core, MVC6, EF Core, Bootstrap and Angular (updated for 2.2)
Less: Getting Started (New)
Using Visual Studio Code for ASP.NET Core Projects
Implementing ASP.NET Web API

Application Name WilderBlog Environment Name Production
Application Ver v4.0.30319 Runtime Framework x86
App Path D:\home\site\wwwroot\ Runtime Version .NET Core 4.6.27617.04
Operating System Microsoft Windows 10.0.14393 Runtime Arch X86