C H A P T E R  20

Using the CLR in SQL Server

For many years, writing business logic has been technology- and software-specific, especially in terms of databases. For example, if you wanted to create a stored procedure or other database object that required complex SQL code, the only way was to code the T-SQL logic in a database and write the calling code in a programming language like C#, as shown in previous chapters where we created a stored procedure using T-SQL in SQL Server and then wrote the calling code in C#.

This approach is still very popular, but there is an easier way that allows C# programmers to take control and code all the database-oriented objects such as stored procedures, functions, and triggers in the .NET language of their ...

Get Beginning C# 5.0 Databases, Second Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.