Developing Managed Code and Executing Within Microsoft SQL Server 2000 - Developing the .NET component
(Page 2 of 5 )
Since this is a very simple demonstration, I will try to create a simple .NET component with only one method, which accepts two integer values as parameters and returns their sum.
You can start opening your Visual Studio and proceed through the following steps:
- Go to File -> New -> Project.
- Select “Class Library” as the Project Template and specify the “Name” of the project as “MySample”. You will be presented with a default class, “Class1.”
- Within the “Solution Explorer”, right click on “Class1” and delete it.
- Again within the “Solution Explorer”, right click on the project, go to Add -> Add Class.
- Give the name of the class as “ISample” and modify the code as follows:
Public Interface ISample
Function getSum(ByVal a As Integer, ByVal b As Integer) As Integer
End Interface
- Again within the “Solution Explorer”, right click on the project, go to Add -> Add Class.
- Give the name of the class as “CSample” and modify the code as follows:
Public Class CSample
Implements ISample
Public Function getSum(ByVal a As Integer, ByVal b As Integer) As Integer Implements ISample.getSum
Return a + b
End Function
End Class
- Again within the “Solution Explorer”, double click on “AssemblyInfo.vb” and add the following line at the bottom
<Assembly: AssemblyKeyFile("..\..\MySample.snk")>
- Go to Start -> Programs -> Microsoft Visual Studio.NET 2003 -> Visual Studio.NET tools -> Visual Studio.NET 2003 Command Prompt.
- Go to the path of your project folder (which is “MySample”), using the Command Prompt.
- Type the following command to provide a strong name to the component. The strong name key pair is necessary for registering the component with GAC cache.
Sn –k MySample.snk
- Now build your solution by pressing Ctrl+Shift+B. It should complete successfully. If you receive any errors, doublecheck the path of “MySample.snk”. It should be available in the same project folder (and not in “bin” or any other sub folder).
Next: How to deploy the .NET component >>
More MS SQL Server Articles
More By Jagadish Chaterjee
