Transactions in SQL CLR (CLR Integration)
No chapter on transactions is complete without a discussion of transactions in SQL CLR. Transactions behave so differently in the 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. We will build on the same concepts here and write a simple SQL CLR stored procedure ...
Get Programming Microsoft® SQL Server™ 2008 now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
