the Common Language Runtime (CLR) and the .NET framework SQL Server


show more Understanding the Common Language Runtime (CLR) and the .NET framework provides you with in-depth training on Business. Taught by Martin Guidry as part of the SQL Server: Triggers, Stored Procedures, and Functions show less
please wait ...

Understanding the Common Language Runtime (CLR) and the .NET framework

Now I would like to talk about a very different technique of creating stored procedures and functions. I will create some stored procedures using the .NET framework languages. In the demos I'll focus on C# which is certainly the most popular language, but we can also use any of the hundreds of .NET languages C#, VB.NET, F#, J# IronPython, IronRuby, and many others. It is possible to write a stored procedure at the .NET framework, because both the .NET framework and SQL Server are heavily integrated with the Common Language Runtime, commonly called the CLR.

However, not every version of the CLR is compatible with every other version. So here on the screen I have a chart showing some of the compatibility levels. SQL Server 2005 and 2008 is compatible with the CLR versions 2.0, 3.0, and 3.5. And SQL Server 2012 we still get 2.0, 3.0, 3.5, but we also additionally get 4.0. This can lead to some interesting decisions for a developer as to which version should you write your code in.

But in m...

Understanding the Common Language Runtime (CLR) and the .NET framework
Video duration: 1m 52s 1h 52m Advanced

Viewers:

Understanding the Common Language Runtime (CLR) and the .NET framework provides you with in-depth training on Business. Taught by Martin Guidry as part of the SQL Server: Triggers, Stored Procedures, and Functions

Subjects:
Business Developer IT
Software:
SQL Server
Author:
please wait ...