O'Reilly logo

Beginning C# 5.0 Databases, Second Edition by Vidya Vrat Agarwal

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required