1. Home
  2. LLBLGen Pro
  3. LLBLGen Pro Runtime Framework

LLBLGen on LINQPad

Posts   
 
    
kakaiya
User
Posts: 161
Joined: 20-Mar-2004
# Posted on: 15-Mar-2023 16:14:52   

Hi,

I am trying to use DAL dll in LINQPad and not working.

https://github.com/SolutionsDesign/LINQPadDriver7Plus

Could you please steps to follow and lpx6 file?

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39613
Joined: 17-Aug-2003
# Posted on: 15-Mar-2023 17:04:52   

You tried the linqpad dll from the additional downloads? https://www.llblgen.com/Pages/additionaldownloads.aspx

(that's for 5.10, for older runtimes you have to compile it yourself). Not sure what 'not working' means, it gives an error or something?

Frans Bouma | Lead developer LLBLGen Pro
kakaiya
User
Posts: 161
Joined: 20-Mar-2004
# Posted on: 16-Mar-2023 06:06:08   

Otis, Thank you.

I have downloaded and it shows in LINQPad7 treeview (it is now showing in treeview in LINQPad7), can not write code as getting exception.

TypeInitializationException••• The type initializer for 'SD.LLBLGen.Pro.DQE.SqlServer.DynamicQueryEngine' threw an exception. TargetSite RuntimeMethodInfo••• DynamicQueryEngine.Configure (SQLServerDQEConfiguration configuration) Message The type initializer for 'SD.LLBLGen.Pro.DQE.SqlServer.DynamicQueryEngine' threw an exception. Data (0 items) InnerException ORMGeneralOperationException••• DbProviderFactory information for compatibilitylevel SqlServer2012 wasn't properly initialized. HelpLink null Source SD.LLBLGen.Pro.DQE.SqlServer HResult -2146233036 StackTrace at SD.LLBLGen.Pro.DQE.SqlServer.DynamicQueryEngine.Configure(SQLServerDQEConfiguration configuration) at SD.LLBLGen.Pro.DQE.SqlServer.SQLServerDQEConfiguration.Configure() at SD.LLBLGen.Pro.ORMSupportClasses.RuntimeConfiguration.ConfigureDQE[TDQEConfig](Action`1 configureFunc) at System.RuntimeMethodHandle.InvokeMethod(Object target, Void** arguments, Signature sig, Boolean isConstructor) at System.Reflection.MethodInvoker.Invoke(Object obj, IntPtr* args, BindingFlags invokeAttr) TypeName SD.LLBLGen.Pro.DQE.SqlServer.DynamicQueryEngine

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39613
Joined: 17-Aug-2003
# Posted on: 16-Mar-2023 10:22:44   

This took a while, linqpad had a tough time figuring out how to install stuff from nuget... rage

Anyway I ran into the same problem, after I manually had to install the SQL Server DQE assembly even thought the assemblies I referenced use the right nuget packages... I made the mistake of referencing the .NET FX build which assumes .config files. This error is fixed if you reference the netstandard build of the assembly because linqpad 7 is .net core 3+ and thus you need to use the netstandard builds

Frans Bouma | Lead developer LLBLGen Pro
kakaiya
User
Posts: 161
Joined: 20-Mar-2004
# Posted on: 18-Mar-2023 07:22:22   

Hi Otis,

Thank you.