Cannot call Engine.Razor.RunCompile twice in application

[ssharmagithub]

i am getting error when i call Engine.Razor.RunCompile twice with two different sql source.

string sql = Engine.Razor.RunCompile(sqlTmplt, Guid.NewGuid().ToString(), null, request);

Error:

Errors while compiling a Template.
Please try the following to solve the situation:

• If the problem is about missing/invalid references or multiple defines either try to load
  the missing references manually (in the compiling appdomain!) or
  Specify your references manually by providing your own IReferenceResolver implementation.
  See https://antaris.github.io/RazorEngine/ReferenceResolver.html for details.
  Currently all references have to be available as files!
• If you get 'class' does not contain a definition for 'member':
  try another modelType (for example 'null' to make the model dynamic).
  NOTE: You CANNOT use typeof(dynamic) to make the model dynamic!
  Or try to use static instead of anonymous/dynamic types.
  More details about the error:

• error: (9, 89) The type 'TemplateBase' exists in both 'RazorEngine.NetCore, Version=0.0.0.0, Culture=neutral, PublicKeyToken=9ee697374c7e744a' and 'RazorEngine, Version=3.2.0.0, Culture=neutral, PublicKeyToken=9ee697374c7e744a'
  • error: (12, 66) 'RazorEngine_fbe26ed1a83842f9af305e68c4bee0c5.ExecuteAsync()': no suitable method found to override
  • error: (14, 12) The name 'WriteLiteral' does not exist in the current context
  • error: (15, 12) The name 'WriteLiteral' does not exist in the current context
    Temporary files of the compilation can be found in (please delete the folder): D:\Users\SHARM22\AppData\Local\Temp\RazorEngine_ilnncvda.d1b
    The template we tried to compile is:
    ------------- START -----------
    select * from TABLE_NAME Where OrderID = @@0
    ------------- END -----------

The generated source code is:
------------- START -----------
//
#pragma warning disable 1591
namespace CompiledRazorTemplates.Dynamic
{
#line hidden
using System.Threading.Tasks;
using System;
using System.Collections.Generic;
using System.Linq;
internal class RazorEngine_fbe26ed1a83842f9af305e68c4bee0c5 : RazorEngine.Templating.TemplateBase<System.Collections.Generic.IDictionary<System.String, System.Object>>
{
#pragma warning disable 1998
public async override global::System.Threading.Tasks.Task ExecuteAsync()
{
WriteLiteral("select * from TABLE_NAME Where OrderID = ");
WriteLiteral("@0");
}
#pragma warning restore 1998
}
}
#pragma warning restore 1591

------------- END -----------

List of loaded Assemblies:
C:\Program Files\dotnet\shared\Microsoft.NETCore.App\3.1.7\System.Private.CoreLib.dll
Loaded Assembly: D:\Users\SHARM22.dotnet\tools.store\amazon.lambda.testtool-3.1\0.10.1\amazon.lambda.testtool-3.1\0.10.1\tools\netcoreapp3.1\any\Amazon.Lambda.TestTool.WebTester31.dll
Loaded Assembly: C:\Program Files\dotnet\shared\Microsoft.NETCore.App\3.1.7\System.Runtime.dll
Loaded Assembly: D:\Users\SHARM22.dotnet\tools.store\amazon.lambda.testtool-3.1\0.10.1\amazon.lambda.testtool-3.1\0.10.1\tools\netcoreapp3.1\any\Amazon.Lambda.TestTool.dll
Loaded Assembly: C:\Program Files\dotnet\shared\Microsoft.NETCore.App\3.1.7\System.Runtime.Extensions.dll
Loaded Assembly: C:\Program Files\dotnet\shared\Microsoft.AspNetCore.App\3.1.7\Microsoft.AspNetCore.Mvc.Core.dll
Loaded Assembly: C:\Program Files\dotnet\shared\Microsoft.NETCore.App\3.1.7\System.Console.dll
Loaded Assembly: C:\Program Files\dotnet\shared\Microsoft.NETCore.App\3.1.7\System.Threading.dll
Loaded Assembly: C:\Program Files\dotnet\shared\Microsoft.NETCore.App\3.1.7\System.Text.Encoding.Extensions.dll
Loaded Assembly: C:\Program Files\dotnet\shared\Microsoft.NETCore.App\3.1.7\System.IO.FileSystem.dll
Loaded Assembly: C:\Program Files\dotnet\shared\Microsoft.NETCore.App\3.1.7\System.Diagnostics.Debug.dll
Loaded Assembly: C:\Program Files\dotnet\shared\Microsoft.NETCore.App\3.1.7\System.Linq.dll
Loaded Assembly: C:\Program Files\dotnet\shared\Microsoft.NETCore.App\3.1.7\System.Memory.dll
Loaded Assembly: C:\Program Files\dotnet\shared\Microsoft.NETCore.App\3.1.7\System.Runtime.InteropServices.dll
Loaded Assembly: C:\Program Files\dotnet\shared\Microsoft.NETCore.App\3.1.7\System.Collections.dll
Loaded Assembly: C:\Program Files\dotnet\shared\Microsoft.NETCore.App\3.1.7\System.Runtime.Loader.dll
.......................................

[mageshn18]

Did you find what caused the issue. I am running into a similar issue now in Prod.

[mageshn18]

error: (9, 89) The type 'TemplateBase' exists in both 'RazorEngine.NetCore, Version=0.0.0.0, Culture=neutral, PublicKeyToken=9ee697374c7e744a' and 'RazorEngine, Version=3.2.0.0, Culture=neutral, PublicKeyToken=9ee697374c7e744a'
error: (12, 66) 'RazorEngine_fbe26ed1a83842f9af305e68c4bee0c5.ExecuteAsync()': no suitable method found to override

We found the issue , we had both the dlls present in the deployed folder. causing the issue.