Hello. So sorry for the long delay in responding.
Thanks for updating your table up to 2022.
Which table are you referring to? I haven't actually had a chance to update the table in this article, and I do need to do that. But, I believe I have updated a similar table in an answer on StackOverflow ( "Which version of .NET framework SQL Server supports?" ). Is that what you were referring to? Just curious 😉
I tried to find a Microsoft Road Map to see where .Net 6 ,7,8 fit in the SQLCLR picture.
I doubt such a roadmap exists as, unfortunately, I don't know when (or even if) Microsoft is going to make any improvements in their CLR integration. Which is truly disheartening given what can already be accomplished with SQLCLR and how much more potential there is with even minimal improvements. However, I believe that they do not currently have anyone who truly understands the CLR integration feature, and are instead trying to push everyone to use the newer "external scripts" feature (that can make use of R, Python, JAVA, and C#, which is nice). I get the sense that the folks at Microsoft are under the mistaken belief that external scripts can accomplish the same things that CLR integration can, and it simply cannot: it's only a stored procedure API, meaning no scalar functions, TVFs, triggers, user-defined aggregates, user-defined types, context connection (to access objects within the calling transaction, etc), etc. SAD!
I got a mixed bag of results, where the console app was FASTER if the data retrieved from the API was large - like 1 meg + . For smaller returned streams, SQLCLR was faster. I put these differences on the latency of calling the console.
Yes, the startup overhead of executing a program in a command window does add up over many calls. I have experienced that myself. Executing many SQL scripts in separate calls of SQLCMD is much slower than executing all of those same scripts, concatenated together, in a single call of SQLCMD.
Thanks for the staircase, as it has helped me a lot over the years.
You are quite welcome. I'm glad the info has been helpful and hopefully I will soon be able to complete the series by including articles on each object type.