Use c# for SQL extended stored procedure

[scanner2001]

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

 

[Dmitriy Lapshin [C# / .NET MVP]]

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.