Sql 2005 and managed code...

Today  I proposed an idea to my boss which included using Sql 2005 in a manor that I "think" is possible.

What I mean by that is I know Sql 2005 can store managed code as stored procedures...and I know to do that you compile the stored procedure, put it someplace that the database can find, and then make t-sql like statements to reference the .dll's static methods.

On a very high level, my idea involves an automation execution engine.  Test case information is feed to this engine as C# compiled .dll's.  What I would like is for these .dll's to be stored in a test case table in a database, and to be able to feed these to the engine from the database.

I'm going to begin research on the posibility of this tomorrow, but I thought I'd make a post on it and see if anyone had a suggestion on where to start investigating (or tell me it's flat out not possible).

Anyway, love to hear anyone's thoughts.  :)

Comments

• Anonymous
  March 01, 2006
  The comment has been removed
• Anonymous
  March 01, 2006
  I think my question is more of, can you store a class from a .dll as data in a table, which in could then be passed in as a delegate to the automation engine?