How to create a CLR DLL for Sql Server 2005? Is it just any .net class library that you can load into Sql Server 2005 or is there some special project type that I need to start with?

How to create a CLR DLL for Sql Server 2005? Is it just any .net class
library that you can load into Sql Server 2005 or is there some special
project type that I need to start with?

Oct 23 '07 #1

Subscribe Post Reply

1589

Tom Shelton

On Oct 23, 2:55 pm, "DR" <softwareengineer98...@yahoo.comwrote:

How to create a CLR DLL for Sql Server 2005? Is it just any .net class
library that you can load into Sql Server 2005 or is there some special
project type that I need to start with?

It's essentially a dll... The procedures are just methods with
special attributes.

--
Tom Shelton

Oct 23 '07 #2

Lloyd Sheen

"Tom Shelton" <to*********@comcast.netwrote in message
news:11********************@i38g2000prf.googlegrou ps.com...

On Oct 23, 2:55 pm, "DR" <softwareengineer98...@yahoo.comwrote:
>How to create a CLR DLL for Sql Server 2005? Is it just any .net class
library that you can load into Sql Server 2005 or is there some special
project type that I need to start with?

It's essentially a dll... The procedures are just methods with
special attributes.

--
Tom Shelton

File/New Project/Visual Basic/Database. Then when you add you will see the
list of CLR DLL that you can add (ie Aggregate/Stored Procedure etc)

Hope this helps
LS

Oct 23 '07 #3

Tom Shelton

On Oct 23, 4:20 pm, "Lloyd Sheen" <a...@b.cwrote:

"Tom Shelton" <tom_shel...@comcast.netwrote in message

news:11********************@i38g2000prf.googlegrou ps.com...

On Oct 23, 2:55 pm, "DR" <softwareengineer98...@yahoo.comwrote:
How to create a CLR DLL for Sql Server 2005? Is it just any .net class
library that you can load into Sql Server 2005 or is there some special
project type that I need to start with?

It's essentially a dll... The procedures are just methods with
special attributes.

--
Tom Shelton

File/New Project/Visual Basic/Database. Then when you add you will see the
list of CLR DLL that you can add (ie Aggregate/Stored Procedure etc)

Hope this helps
LS

Sure. I know how to create one. I guess I should have added that,
but I guess I thought the OP was asking if you HAD to use the project
template.... And the answer is no, it is essentially a library. I
see now that he was probably asking how to create one :)

--
Tom Shelton

Oct 23 '07 #4

Similar topics

Upgrading a web application to VS 2005

by: Mike Owen | last post by:

Hi, I have just used the import Wizard to import a VS 2003 app to VS 2005. I have a lot of work to do to enable it to compile successfully with all the errors and warnings it gave me, but as a...

.NET Framework

How do I create pdf reports from Access?

by: dog | last post by:

I've seen plenty of articles on this topic but none of them have been able to solve my problem. I am working with an Access 97 database on an NT4.0 machine, which has many Access reports. I...

Microsoft Access / VBA

create a wrapped managed dll that can be used from pure unmanagedcode

by: bonk | last post by:

Hello, I am trying to create a dll that internally uses managed types but exposes a plain unmanaged interface. All the managed stuff shall be "wrapped out of sight". So that I would be able to...

.NET Framework

Windows Service cannot create text files?

by: Amjad | last post by:

Hi, I just wrote a test Windows Service that creates a text file on startup (please see my code below). The file is never created. Protected Overrides Sub OnStart(ByVal args() As String) Dim...

Visual Basic .NET

Cannot create ASP.Net project in Visual Studio .Net 2003

by: JonSteng | last post by:

..Net Visual Studio Professional 2003 Version 7.1.3088 ..Net Framework 1.1 SP1 Version 1.1.4322 IIS 5.1 Windows XP Professional SP2 Micron T3000 Laptop (1.5 GHz; 1GB RAM; 40GB HD with 17GB Free)...

ASP.NET

Visual Studio 2005

by: Mads Peter Nymand | last post by:

Hi, Background: I'm a Java programmer new to c# and Visual Studio. Problem: When I compile in Visual Studio 2005, the compiler complains, that it can not find several different namespaces....

C# / C Sharp

Create DLL in Visual Studio 2005 accessible by Excel 2002

by: Steve | last post by:

I am trying to create a DLL in Visual Studio 2005-Visual Basic that contains custom functions. I believe I need to use COM interop to allow VBA code in Excel 2002 to access it. I've studied...