Working with CLR Objects in SQL Server 2005 or Above Part 2

Abhishek Sur

Rate me:

5.00/5 (13 votes)

2 Aug 2009CPOL7 min read

278K

424

Gives an introduction of how to create SQL CLR managed objects in SQL server.

sqlserverclr_csharp.zip
- SqlServerCLR
  - SqlServerCLR.sln
  - SqlServerCLR.suo
  - SqlServerCLR
    - bin
      - Debug
        
        SqlServerCLR.dll
        
        SqlServerCLR.pdb
    - obj
      - Debug
        
        Refactor
        
        SqlServerCLR.csproj.FileListAbsolute.txt
        
        SqlServerCLR.dll
        
        SqlServerCLR.pdb
        
        TempPE
    - Properties
      - AssemblyInfo.cs
    - SqlServerCLR.csproj
    - SqlServerCLR.csproj.user
    - Test Scripts
      - Test.sql
    - xsp_ExportData.cs
    - xudaf_AsciiSum.cs
    - xudf_GetSquare.cs
    - xut_GeoPoint.cs
    - xut_UpdateDateTime.cs
sqlserverclr_vb.net.zip
- SQLServerCLR_VB
  - SQLServerCLR_VB.sln
  - SQLServerCLR_VB.suo
  - SQLServerCLR_VB
    - bin
      - SQLServerCLR_VB.dll
      - SQLServerCLR_VB.pdb
    - My Project
      - AssemblyInfo.vb
    - obj
      - Debug
        
        SQLServerCLR_VB.dll
        
        SQLServerCLR_VB.pdb
        
        SQLServerCLR_VB.vbproj.FileListAbsolute.txt
        
        TempPE
    - SQLServerCLR_VB.vbproj
    - SQLServerCLR_VB.vbproj.user
    - Test Scripts
      - Test.sql
    - xsp_ExportData.vb
    - xudaf_AsciiSum.vb
    - xudf_GetSquare.vb
    - xut_GeoPoint.vb
    - xut_UpdateDateTime.vb

Imports System
Imports System.Reflection
Imports System.Runtime.InteropServices
Imports System.Data.Sql

' General Information about an assembly is controlled through the following
' set of attributes. Change these attribute values to modify the information
' associated with an assembly.

' Review the values of the assembly attributes

<Assembly: AssemblyTitle("SQLServerCLR_VB")>
<Assembly: AssemblyDescription("")>
<Assembly: AssemblyCompany("Value")>
<Assembly: AssemblyProduct("SQLServerCLR_VB")>
<Assembly: AssemblyCopyright("Copyright © Value 2009")>
<Assembly: AssemblyTrademark("")>
<Assembly: CLSCompliant(True)>
<Assembly: ComVisible(False)>

'The following GUID is for the ID of the typelib if this project is exposed to COM
<Assembly: Guid("479ca22b-6d38-4ed2-a9fb-448751af7283")>

' Version information for an assembly consists of the following four values:
'
'      Major Version
'      Minor Version
'      Build Number
'      Revision
'
' You can specify all the values or you can default the Build and Revision Numbers 
' by using the '*' as shown below:

<Assembly: AssemblyVersion("1.0.*")>

By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.

If a file you wish to view isn't highlighted, and is a text file (not binary), please let us know and we'll add colourisation support for it.

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Written By

Abhishek Sur

President

India

Did you like his post?

Oh, lets go a bit further to know him better.
Visit his Website : www.abhisheksur.com to know more about Abhishek.

Abhishek also authored a book on .NET 4.5 Features and recommends you to read it, you will learn a lot from it.
http://bit.ly/EXPERTCookBook

Basically he is from India, who loves to explore the .NET world. He loves to code and in his leisure you always find him talking about technical stuffs.

Working as a VP product of APPSeCONNECT, an integration platform of future, he does all sort of innovation around the product.

Have any problem? Write to him in his Forum.

You can also mail him directly to abhi2434@yahoo.com

Want a Coder like him for your project?
Drop him a mail to contact@abhisheksur.com

Visit His Blog

Dotnet Tricks and Tips

Dont forget to vote or share your comments about his Writing

Working with CLR Objects in SQL Server 2005 or Above Part 2

License

Comments and Discussions