Scripting in .Net using CodeDom

[fred_mumble]

I have been testing various techniques to run "script" code which will
be stored in a SQL database and executed dynamically at runtime. The
scripts are essentially business rules that result in a report being
generated based on test parameters input by a user - 4 batches of
scripts containing multiple functions will be run each time a user runs
a new test. The reason the scripts are run in 4 batches is due to the
fact that each batch is built upon the results of the prior batch. I
have been leaning towards a VB type language since it is well known and
supports the type of functionality required.

Since the application is being written in .Net my initial thought was
to use VSA. Using this technique I was running into serious memory
leaks (on the order of 1M for each batch of scripts) on each test run.
Next I switched to manually using CodeDom and creating a new AppDomain
for each batch of scripts using a class factory approach. This worked
much better, but still results in leaking about 400 bytes for each
batch of scripts run. Plus I could only run about 6 batches of scripts
per second. Following are the compiler parameters being set which are
meant to be as efficient as possible:

CompilerParamet ers cParams = new CompilerParamet ers();
cParams.Compile rOptions = "/target:library /optimize";
cParams.Generat eExecutable = false;
cParams.Generat eInMemory = true;
cParams.Include DebugInformatio n = false;

After a lot of testing and debate I decided to test out using the
Microsoft Script Control. The results were over 300 times faster
(2,887 batches of scripts per second versus 6) with no memory leaks.
Following is a sample of what I put into a test loop:

MSScriptControl .ScriptControl sc = new
MSScriptControl .ScriptControlC lass();

sc.Language = "VBScript";
sc.AddCode(Test COMScript);

Object[] oParams = new Object[2] { new Random().Next(1 000), new
Random().Next(1 000) };
sc.Run("GetNumb er", ref oParams).ToStri ng();

System.Runtime. InteropServices .Marshal.Releas eComObject(sc);

The decision seems to be a no-brainer, but I wanted to see if anyone
has an idea of how this can be accomplished using only managed code but
without such a large performance hit or the memory leaks. I really
hate to use an ActiveX object on an otherwise purely managed
application.

[Stefan Simek]

Hi Fred!

This is exactly why I've started to write a purely managed scripting engine
for .NET. Microsoft has, for some unknown reasons, forsaken the interpreting
script support and forces us to compile everything instead (which is
completely unnecessary when you want to execute dynamic code). Or at least
I'm not aware of any managed way to execute code dynamically without
compiling.

BTW., I've finally found some time to get back to my scripting library (I've
announced it some time ago), so some early bits should be available soon.

Stefan

<fr*********@ya hoo.com> wrote in message
news:11******** *************@f 14g2000cwb.goog legroups.com...

I have been testing various techniques to run "script" code which will
be stored in a SQL database and executed dynamically at runtime. The
scripts are essentially business rules that result in a report being
generated based on test parameters input by a user - 4 batches of
scripts containing multiple functions will be run each time a user runs
a new test. The reason the scripts are run in 4 batches is due to the
fact that each batch is built upon the results of the prior batch. I
have been leaning towards a VB type language since it is well known and
supports the type of functionality required.

Since the application is being written in .Net my initial thought was
to use VSA. Using this technique I was running into serious memory
leaks (on the order of 1M for each batch of scripts) on each test run.
Next I switched to manually using CodeDom and creating a new AppDomain
for each batch of scripts using a class factory approach. This worked
much better, but still results in leaking about 400 bytes for each
batch of scripts run. Plus I could only run about 6 batches of scripts
per second. Following are the compiler parameters being set which are
meant to be as efficient as possible:

CompilerParamet ers cParams = new CompilerParamet ers();
cParams.Compile rOptions = "/target:library /optimize";
cParams.Generat eExecutable = false;
cParams.Generat eInMemory = true;
cParams.Include DebugInformatio n = false;

After a lot of testing and debate I decided to test out using the
Microsoft Script Control. The results were over 300 times faster
(2,887 batches of scripts per second versus 6) with no memory leaks.
Following is a sample of what I put into a test loop:

MSScriptControl .ScriptControl sc = new
MSScriptControl .ScriptControlC lass();

sc.Language = "VBScript";
sc.AddCode(Test COMScript);

Object[] oParams = new Object[2] { new Random().Next(1 000), new
Random().Next(1 000) };
sc.Run("GetNumb er", ref oParams).ToStri ng();

System.Runtime. InteropServices .Marshal.Releas eComObject(sc);

The decision seems to be a no-brainer, but I wanted to see if anyone
has an idea of how this can be accomplished using only managed code but
without such a large performance hit or the memory leaks. I really
hate to use an ActiveX object on an otherwise purely managed
application.