Hey,
I have a database which holds thousands of relational records regarding financial information. This information can easily be pivotted to give us reports of various forms. We have a reporting system written in asp.net but the pages are static and generally not very scalable. I'd like to introduce a method where by the report elements (filter elements such as drop down lists etc) are held within a table in the database and then constructed on the fly when a report type is chosen. The problem I have is that the drop down lists for these reports need to have event handlers defined dynamically, ideally with code taken from a field in the database.
Is this even possible? I am very familiar with reflection, but not executing and compiling code that is stored within a database record
Thanks in advance
M
Dusan TkacPosted Dec 4, 2008, 12:07 PM
Hi,
I have experience with assemblies stored in database and dynamically loaded and executed at run time. It works, but you have to carefull with few things:
- dependencies - what these stored assemblies reference;
- how do you load them into application domain - into which load-context;
- what whould you do if assembly is updated in database - do you want to load a new wersion
- is it possible to load the same version of assembly into app domain repeatedly? (consumes memory) If not, how would you prevent it.