- ago
Hi,
for data exchange between wl8 and a Python venv, I would like to use a MySQL-database as a conduit. For this purpose, I created a strategy in Visual Studio which on its own works correctly (aka wl8 is opened, the strategy is shown and can be debugged).
Then I implemented EF Core6 and revered-engineered that db scheme of interest into this project. This worked also.
But when I try to start the strategy then, and wl8 is opened, the strategy cannot be seen and selected anymore...

The csproj-file looks like this now:

CODE:
<Project Sdk="Microsoft.NET.Sdk"> <PropertyGroup> <TargetFramework>net6.0</TargetFramework> <OutputPath>C:\Program Files\Quantacula, LLC\WealthLab 8</OutputPath> <AppendTargetFrameworkToOutputPath>false</AppendTargetFrameworkToOutputPath> <AppendRuntimeIdentifierToOutputPath>false</AppendRuntimeIdentifierToOutputPath> <ImplicitUsings>enable</ImplicitUsings> <Nullable>enable</Nullable> <Platforms>AnyCPU;x64</Platforms> </PropertyGroup> <ItemGroup> <PackageReference Include="Microsoft.EntityFrameworkCore" Version="6.0.16" /> <PackageReference Include="Microsoft.EntityFrameworkCore.Design" Version="6.0.16"> <PrivateAssets>all</PrivateAssets> <IncludeAssets>runtime; build; native; contentfiles; analyzers; buildtransitive</IncludeAssets> </PackageReference> <PackageReference Include="MySql.EntityFrameworkCore" Version="6.0.16" /> <PackageReference Include="Pomelo.EntityFrameworkCore.MySql" Version="6.0.2" /> </ItemGroup> <ItemGroup> <Reference Include="WealthLab.Core"> <HintPath>WealthLab.Core.dll</HintPath> </Reference> </ItemGroup> </Project>


Do you have an idea what the problem, and if it can be fixed?

Many thx,
Patrick
0
526
5 Replies

Reply

Bookmark

Sort
Glitch8
 ( 10.10% )
- ago
#1
Are there any messages in the WL8 log? It’s possible you didn’t copy some or all of the dlls required by the EF into the WL8 folder?
0
- ago
#2
Hello Dion,
missing dll's were part of the problem. thx for pointing that out.

But when I now start the strategy in VS22, after a while the following error appears:



I have looked quite a while in the internet regarding this, but could not find a solution. It is a bit weird, since the mentioned dll is in principal there:

Screenshot of included dll. for some reason, I cannot paste the pic right now...

If somebody has an idea how to get this to work, I would be super thankful.

For full disclosure, in the meantime, I have realized the basic functionality of this with ADO.NET and this works. Nevertheless, if one has worked once with EF Core and LINQ/Lambda expressions, it is really difficult to go back ;-)
0
- ago
#3
Seems like a dynamic load is occurring.

In any case, reference the following about dependencies of the DLL it can't find: https://www.nuget.org/packages/Microsoft.Extensions.DependencyInjection.Abstractions/#dependencies-body-tab

Try adding the DLL mentioned in the error message into the WL8 folder and adding it as an assembly reference in WL8. You might have to add the DLLs it depends on and so on and so forth.
1
- ago
#4
Thx Paul, for your reply

But that is just the problem, everything seems to be already there...



0
- ago
#5
I didn't try this, but try adding Microsoft.Bcl.AsyncInterfaces to the WL8 folder. You might also have to add it as an assembly reference to WL8.
0

Reply

Bookmark

Sort