Use c# for SQL extended stored procedure



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
Any suggestions on how to proceed? Or should I post to a different




Dmitriy Lapshin [C# / .NET MVP]


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.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question