Beginning C# 5.0 Databases, Second Edition

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 ...