By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,433 Members | 776 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,433 IT Pros & Developers. It's quick & easy.

Use c# for SQL extended stored procedure

P: n/a
Here is what I would like to be able to do,
Have an SQL extended stored procedure to do file copy, delete, and
rename(move) procedures.
I have written the code in C# to do this, in the form of a simple app,
and it contains all of the functionality, error handling, etc. that I need.
I would like to use the extended stored procedure framework from visual
studio, but I am unsure how to merge these two together.
I do "not" want to make a dll, then call it using sp_OA... stored
procedures.
Any suggestions on how to proceed? Or should I post to a different
newsgroup?

Thanks,
Jeff
Nov 15 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Hi,

The simplest answer is that you'll have to wait for the next version of SQL
Server where stored procedures can be written in managed code. With current
version, your only choice will probably be to create a "wrapper" DLL
implementing the extended stored procedure interface which, in turn, will be
hosting the .NET framework and running the managed code.

--
Dmitriy Lapshin [C# / .NET MVP]
X-Unity Test Studio
http://x-unity.miik.com.ua/teststudio.aspx
Bring the power of unit testing to VS .NET IDE

"scanner2001" <sc**********@yahoo.com> wrote in message
news:xD*******************@newsread1.news.atl.eart hlink.net...
Here is what I would like to be able to do,
Have an SQL extended stored procedure to do file copy, delete, and
rename(move) procedures.
I have written the code in C# to do this, in the form of a simple app,
and it contains all of the functionality, error handling, etc. that I need. I would like to use the extended stored procedure framework from visual studio, but I am unsure how to merge these two together.
I do "not" want to make a dll, then call it using sp_OA... stored
procedures.
Any suggestions on how to proceed? Or should I post to a different
newsgroup?

Thanks,
Jeff


Nov 15 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.