Using C # assembly in SQL Server

Question

I have a C # class library that I am calling from an asp.net application. The assembly calculates grades for students and performs calculations using data, etc.

How can I use this assembly in SQL Server 2005 and call it once for each record in the database table? I want to reuse functionality and not write things in T-SQL.

Answer 1

To use .NET assemblies in SQL Server, you need to enable CLR integration on the SQL server. There are some good examples in this MSDN section.

Since you have the logic already in .Net, would it be better to do all the work there? As your application grows, it will be much better for you to store all your business logic in code and use the database as a data warehouse.