Transactions in SQL CLR (CLR Integration)
No chapter on transactions is complete without a discussion of transactions in SQL CLR. Transactions behave so differently with SQL CLR that this topic warrants its own section.
So far, we have discussed local transactions in SQL Server and ADO.NET, as well as distributed transactions in ADO.NET, SQL Server, and the .NET Framework in general. We noted that in PSPE, a distributed transaction might not be distributed. Thus, the boundaries of what is distributed and what is not are already blurry. Well in SQL CLR, they are not only blurry, they are downright indistinct.
In Chapter 3, you learned about the basics of SQL CLR. Here, you will build on the same concepts and write a simple SQL CLR stored procedure ...