The CLR included with SQL Server 2005 (I don't know about 2008 yet) has a limited set of Base .Net Assemblies. Unlike the very large library of base Assemblies made available in the 2.0, 3.0, or 3.5 Frameworks. So, for example, say I had a field in a table called Date of Birth. I wanted to determine who in that table was born in a Leap Year. My choices in the past a Cursor or a T-SQL SP that would loop though each record in the table to determine who was born in a Leap Year. Now, I have another choice of writing a Managed SP utilizing .Net Math.
Now say I want a Managed SP that will populate a field in a table with a calculated Hash value ( I don't know base off of their Name and DOB say). The framework has a few different methods using the Security Assembly, but this Assembly is not in the SQL Server CLR. Now can I manually add this assembly or write my own Assembly and add it to the SQL Environment? Yes I can, but there are two considerations: (1) There is a reason why Microsoft chooses to not include that Assembly. Namely, it may not be Thread Safe. Or (2) that Assembly may be Thread Safe but due to inheritance and references, an associated (required) Assembly may not be registered. I tried this for the example above and found about 5 layers for associated assemblies I would have had to register before I gave up. To avoid any hidden problems and creating a highly customized environment, I would rather write a managed application that would do a one update adding the Hash values and modify the UI to create the Hash when the new records were added to the DB. On Sep 11, 11:07 pm, Melting_flames <[EMAIL PROTECTED]> wrote: > So u mean to say i have to dynamically load the dll and call the > function? > i'm not clear on the answer to this. can u explain. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "DotNetDevelopment, VB.NET, C# .NET, ADO.NET, ASP.NET, XML, XML Web Services,.NET Remoting" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://cm.megasolutions.net/forums/default.aspx <p><a href="http://feeds.feedburner.com/DotNetDevelopment";><img src="http://feeds.feedburner.com/~fc/DotNetDevelopment?bg=99CCFF&fg=444444&anim=1"; height="26" width="88" style="border:0" alt="" /></a></p> -~----------~----~----~----~------~----~------~--~---
