Nsryjdtyk

I scratching my head on this issue. I build a plugin architecture with Excel DNA, and I want to compile new functions at runtime and register them in Excel DNA.
It works perfectly fine until I try to access static data in the new functions context. My static data Toto is null.

When adding some logs, I discovered that the static constructor of RuntimeCompiler was called twice.
It seems that new functions are running in a different memory space. However, when I log the Appdomain Id, in the function and outside, it seems to be the same.

The code is working perfectly well in a unit test. So that is why I think it is related with the Excel/Excel DNA memory management.

How can I share the same memory space with my new loaded functions ?

Has anyone have already experienced this issue. ?

Thanks a lot

alpaga

namespace  test.xl.Loader

{



 public static class RuntimeCompiler

    {



        public static string Toto { get; set; }



        public static void CreateAndRegisterFunctions()

        {

            try

            {

                var wrapperClassPath =     CreateWrapperClassFromServiceDefinition();



                if (wrapperClassPath == null) return;



                var assemblyPath = CompileExecutable(wrapperClassPath);



                if (assemblyPath == null) return;



                var methodsToRegister =     GetMethodsFromAssembly(assemblyPath);



                if (methodsToRegister == null) return;



                ExcelAsyncUtil.QueueAsMacro(() =>     Integration.RegisterMethods(methodsToRegister));



            }

            catch (Exception e)

            {

                _logger.ErrorFormat(e.Message);

            }

        }



         private static string CreateWrapperClassFromServiceDefinition()

        {

            try

            {



                    Toto = "lol";



                    var generatedClass = @"



using System;

using System.Collections.Generic;

using System.Text;

using System.Linq;

using System.Threading.Tasks;

using test.xl.Loader;



namespace  A

{

    public class Wrapper

    {

        public static object FlGetToto(string arg)

        {

            return test.xl.Loader.RuntimeCompiler.Toto;

        }

    }

}

                    ";



                    var tmp = Path.GetTempFileName()+".cs";



                    using (var file = new StreamWriter(tmp))

                    {

                        file.Write(generatedClass);

                    }



                    return tmp;



            }

            catch (Exception e)

            {

                _logger.Error($"Fail while creating Wrapper Class :     {e.Message}");

                return null;

            }

        }   



        private static List<MethodInfo> GetMethodsFromAssembly(string     assemblyPath)

        {

            try

            {

                var dllName = Path.GetFileName(assemblyPath);



                var assemblyFullName = AssemblyName.GetAssemblyName($".\    {dllName}");



                var assembly = Assembly.Load(assemblyFullName);



                AppDomain.CurrentDomain.Load(assembly.GetName());



                Type myType = assembly.GetType("A.Wrapper");



                return myType.GetMethods().ToList().Where(x => x.Module.Name     == dllName).ToList();

            }

            catch (Exception e)

            {

                _logger.Error($"Fail while getting methods from Assembly :     {e.Message}");

                return null;

            }

        }

    }

}