Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Other SQL Server 2008 Topics
 CLR without Visual Studio?

Author  Topic 

malachi151
Posting Yak Master

152 Posts

Posted - 2012-02-27 : 09:43:14
I know this topic is old, but I'm new to CLR programming and after looking through a lot of tutorials, etc. I'm still finding it hard getting started.

What are the options for CLR programming without Visual Studio? I see a lot of stuff about using Visual Studio, but I don't have Visual Studio or any need for it other than for CLR development. I have C# Express and Web Developer Express, but neither of them give the option to create a SQL project.

So what's the best way to develop CLR code for SQL without a paid version of Visual Studio?

RickD
Slow But Sure Yak Herding Master

3608 Posts

Posted - 2012-02-27 : 12:07:11
All you are building is an assembly, so a dll. C# Express will be fine, you just need to deploy it to the server and then build the assembly in SQL. Microsoft have plenty of information on this or a quick google search for CREATE ASSEMBLY will turn up a load of results for you.
Go to Top of Page

malachi151
Posting Yak Master

152 Posts

Posted - 2012-02-27 : 12:24:27
quote:
Originally posted by RickD

All you are building is an assembly, so a dll. C# Express will be fine, you just need to deploy it to the server and then build the assembly in SQL. Microsoft have plenty of information on this or a quick google search for CREATE ASSEMBLY will turn up a load of results for you.



Okay, so I should just create a Class Library and then compile it using csc then...

Thanks
Go to Top of Page

RickD
Slow But Sure Yak Herding Master

3608 Posts

Posted - 2012-02-28 : 04:22:23
Yes, have a look these:

http://floatleft.wordpress.com/2007/11/04/clr-procedure-deployment-without-visual-studio-2005/
http://msdn.microsoft.com/en-us/library/ms345099.aspx
http://msdn.microsoft.com/en-us/library/ms254956(v=vs.80).aspx
Go to Top of Page

malachi151
Posting Yak Master

152 Posts

Posted - 2012-02-28 : 07:23:02
quote:
Originally posted by RickD

Yes, have a look these:

http://floatleft.wordpress.com/2007/11/04/clr-procedure-deployment-without-visual-studio-2005/
http://msdn.microsoft.com/en-us/library/ms345099.aspx
http://msdn.microsoft.com/en-us/library/ms254956(v=vs.80).aspx




Great, thanks.

--------------------------------------------------
My blog: http://practicaltsql.net/
Twitter: @RGPSoftware
Go to Top of Page
   

- Advertisement -