ErikEJ / EntityFramework6PowerTools

This is the codebase for Entity Framework 6 Power Tools Community Edition, and modern EF 6 providers for SQL Server and SQL Server Compact
Other
183 stars 27 forks source link

Could not load file or assembly 'System.Memory'... #111

Closed lawrence-vo closed 1 year ago

lawrence-vo commented 1 year ago

Erik,

Apologies if this is not accepted here (and feel free to close it) but after attempts of integrating this into my project, I am running into this error:

System.IO.FileLoadException: 'Could not load file or assembly 'System.Memory, Version=4.0.1.1, Culture=neutral, PublicKeyToken=cc7b13ffcd2ddd51' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040)'

I suspect it has to do with the fact that I am in some kind of dependency hell, most likely caused by Snowflake.Data. This is the packages.config which is failing:

<?xml version="1.0" encoding="utf-8"?>
<packages>
  <package id="AutoMapper" version="10.1.1" targetFramework="net472" />
  <package id="AWSSDK.Core" version="3.7.103.10" targetFramework="net472" />
  <package id="AWSSDK.S3" version="3.7.101.48" targetFramework="net472" />
  <package id="Azure.Core" version="1.26.0" targetFramework="net472" />
  <package id="Azure.Identity" version="1.8.0" targetFramework="net472" />
  <package id="Azure.Storage.Blobs" version="12.14.1" targetFramework="net472" />
  <package id="Azure.Storage.Common" version="12.13.0" targetFramework="net472" />
  <package id="DeltaCompressionDotNet" version="2.0.1" targetFramework="net472" />
  <package id="EntityFramework" version="6.4.4" targetFramework="net472" />
  <package id="ErikEJ.EntityFramework.SqlServer" version="6.6.2" targetFramework="net472" />
  <package id="Extended.Wpf.Toolkit" version="4.4.0" targetFramework="net472" />
  <package id="Fody" version="6.6.4" targetFramework="net472" developmentDependency="true" />
  <package id="Google.Api.Gax" version="4.2.0" targetFramework="net472" />
  <package id="Google.Api.Gax.Rest" version="4.2.0" targetFramework="net472" />
  <package id="Google.Apis" version="1.58.0" targetFramework="net472" />
  <package id="Google.Apis.Auth" version="1.58.0" targetFramework="net472" />
  <package id="Google.Apis.Core" version="1.58.0" targetFramework="net472" />
  <package id="Google.Apis.Storage.v1" version="1.58.0.2742" targetFramework="net472" />
  <package id="Google.Cloud.Storage.V1" version="4.1.0" targetFramework="net472" />
  <package id="log4net" version="2.0.15" targetFramework="net472" />
  <package id="MethodDecorator.Fody" version="1.1.1" targetFramework="net472" />
  <package id="Microsoft.Bcl.AsyncInterfaces" version="7.0.0" targetFramework="net472" />
  <package id="Microsoft.Data.SqlClient" version="5.0.1" targetFramework="net472" />
  <package id="Microsoft.Data.SqlClient.SNI" version="5.0.1" targetFramework="net472" />
  <package id="Microsoft.Extensions.DependencyInjection.Abstractions" version="6.0.0" targetFramework="net472" />
  <package id="Microsoft.Identity.Client" version="4.49.1" targetFramework="net472" />
  <package id="Microsoft.Identity.Client.Extensions.Msal" version="2.25.3" targetFramework="net472" />
  <package id="Microsoft.IdentityModel.Abstractions" version="6.25.1" targetFramework="net472" />
  <package id="Microsoft.IdentityModel.JsonWebTokens" version="6.25.1" targetFramework="net472" />
  <package id="Microsoft.IdentityModel.Logging" version="6.25.1" targetFramework="net472" />
  <package id="Microsoft.IdentityModel.Protocols" version="6.25.1" targetFramework="net472" />
  <package id="Microsoft.IdentityModel.Protocols.OpenIdConnect" version="6.25.1" targetFramework="net472" />
  <package id="Microsoft.IdentityModel.Tokens" version="6.25.1" targetFramework="net472" />
  <package id="Microsoft.NETCore.Platforms" version="7.0.0" targetFramework="net472" />
  <package id="Microsoft.NETCore.Targets" version="5.0.0" targetFramework="net472" />
  <package id="Microsoft.Office.Interop.Excel" version="15.0.4795.1001" targetFramework="net472" />
  <package id="Microsoft.Xaml.Behaviors.Wpf" version="1.1.39" targetFramework="net472" />
  <package id="Mono.Cecil" version="0.11.4" targetFramework="net472" />
  <package id="Newtonsoft.Json" version="13.0.2" targetFramework="net472" />
  <package id="Portable.BouncyCastle" version="1.9.0" targetFramework="net472" />
  <package id="Prism.Core" version="8.1.97" targetFramework="net472" />
  <package id="Prism.Wpf" version="8.1.97" targetFramework="net472" />
  <package id="PropertyChanged.Fody" version="4.1.0" targetFramework="net472" />
  <package id="Snowflake.Data" version="2.0.19" targetFramework="net472" />
  <package id="System.Buffers" version="4.5.1" targetFramework="net472" />
  <package id="System.Configuration.ConfigurationManager" version="7.0.0" targetFramework="net472" />
  <package id="System.Diagnostics.DiagnosticSource" version="7.0.0" targetFramework="net472" />
  <package id="System.IdentityModel.Tokens.Jwt" version="6.25.1" targetFramework="net472" />
  <package id="System.Interactive.Async" version="6.0.1" targetFramework="net472" />
  <package id="System.IO" version="4.3.0" targetFramework="net472" />
  <package id="System.IO.Abstractions" version="19.1.5" targetFramework="net472" />
  <package id="System.IO.Abstractions.TestingHelpers" version="19.1.5" targetFramework="net472" />
  <package id="System.IO.Hashing" version="7.0.0" targetFramework="net472" />
  <package id="System.Linq.Async" version="6.0.1" targetFramework="net472" />
  <package id="System.Memory" version="4.5.5" targetFramework="net472" />
  <package id="System.Memory.Data" version="7.0.0" targetFramework="net472" />
  <package id="System.Net.Http" version="4.3.4" targetFramework="net472" />
  <package id="System.Net.Http.WinHttpHandler" version="7.0.0" targetFramework="net472" />
  <package id="System.Numerics.Vectors" version="4.5.0" targetFramework="net472" />
  <package id="System.Private.Uri" version="4.3.2" targetFramework="net472" />
  <package id="System.Runtime" version="4.3.1" targetFramework="net472" />
  <package id="System.Runtime.CompilerServices.Unsafe" version="6.0.0" targetFramework="net472" />
  <package id="System.Runtime.InteropServices.RuntimeInformation" version="4.3.0" targetFramework="net472" />
  <package id="System.Security.AccessControl" version="6.0.0" targetFramework="net472" />
  <package id="System.Security.Cryptography.Algorithms" version="4.3.1" targetFramework="net472" />
  <package id="System.Security.Cryptography.Encoding" version="4.3.0" targetFramework="net472" />
  <package id="System.Security.Cryptography.Primitives" version="4.3.0" targetFramework="net472" />
  <package id="System.Security.Cryptography.ProtectedData" version="7.0.0" targetFramework="net472" />
  <package id="System.Security.Cryptography.X509Certificates" version="4.3.2" targetFramework="net472" />
  <package id="System.Security.Permissions" version="7.0.0" targetFramework="net472" />
  <package id="System.Security.Principal.Windows" version="5.0.0" targetFramework="net472" />
  <package id="System.Text.Encoding" version="4.3.0" targetFramework="net472" />
  <package id="System.Text.Encodings.Web" version="7.0.0" targetFramework="net472" />
  <package id="System.Text.Json" version="7.0.1" targetFramework="net472" />
  <package id="System.Text.RegularExpressions" version="4.3.1" targetFramework="net472" />
  <package id="System.Threading.Tasks.Extensions" version="4.5.4" targetFramework="net472" />
  <package id="System.ValueTuple" version="4.5.0" targetFramework="net472" />
  <package id="TestableIO.System.IO.Abstractions" version="19.1.5" targetFramework="net472" />
  <package id="TestableIO.System.IO.Abstractions.TestingHelpers" version="19.1.5" targetFramework="net472" />
  <package id="TestableIO.System.IO.Abstractions.Wrappers" version="19.1.5" targetFramework="net472" />
</packages>

I have confirmed that this project works with the following dependencies:

<?xml version="1.0" encoding="utf-8"?>
<packages>
  <package id="Azure.Core" version="1.26.0" targetFramework="net472" />
  <package id="Azure.Identity" version="1.8.0" targetFramework="net472" />
  <package id="EntityFramework" version="6.4.4" targetFramework="net472" />
  <package id="ErikEJ.EntityFramework.SqlServer" version="6.6.2" targetFramework="net472" />
  <package id="Microsoft.Bcl.AsyncInterfaces" version="7.0.0" targetFramework="net472" />
  <package id="Microsoft.Data.SqlClient" version="5.0.1" targetFramework="net472" />
  <package id="Microsoft.Data.SqlClient.SNI" version="5.0.1" targetFramework="net472" />
  <package id="Microsoft.Identity.Client" version="4.49.1" targetFramework="net472" />
  <package id="Microsoft.Identity.Client.Extensions.Msal" version="2.25.3" targetFramework="net472" />
  <package id="Microsoft.IdentityModel.Abstractions" version="6.25.1" targetFramework="net472" />
  <package id="Microsoft.IdentityModel.JsonWebTokens" version="6.25.1" targetFramework="net472" />
  <package id="Microsoft.IdentityModel.Logging" version="6.25.1" targetFramework="net472" />
  <package id="Microsoft.IdentityModel.Protocols" version="6.25.1" targetFramework="net472" />
  <package id="Microsoft.IdentityModel.Protocols.OpenIdConnect" version="6.25.1" targetFramework="net472" />
  <package id="Microsoft.IdentityModel.Tokens" version="6.25.1" targetFramework="net472" />
  <package id="System.Buffers" version="4.5.1" targetFramework="net472" />
  <package id="System.Configuration.ConfigurationManager" version="7.0.0" targetFramework="net472" />
  <package id="System.Diagnostics.DiagnosticSource" version="7.0.0" targetFramework="net472" />
  <package id="System.IdentityModel.Tokens.Jwt" version="6.25.1" targetFramework="net472" />
  <package id="System.IO" version="4.3.0" targetFramework="net472" />
  <package id="System.Memory" version="4.5.5" targetFramework="net472" />
  <package id="System.Memory.Data" version="7.0.0" targetFramework="net472" />
  <package id="System.Net.Http" version="4.3.4" targetFramework="net472" />
  <package id="System.Numerics.Vectors" version="4.5.0" targetFramework="net472" />
  <package id="System.Runtime" version="4.3.1" targetFramework="net472" />
  <package id="System.Runtime.CompilerServices.Unsafe" version="6.0.0" targetFramework="net472" />
  <package id="System.Runtime.InteropServices.RuntimeInformation" version="4.3.0" targetFramework="net472" />
  <package id="System.Security.AccessControl" version="6.0.0" targetFramework="net472" />
  <package id="System.Security.Cryptography.Algorithms" version="4.3.1" targetFramework="net472" />
  <package id="System.Security.Cryptography.Encoding" version="4.3.0" targetFramework="net472" />
  <package id="System.Security.Cryptography.Primitives" version="4.3.0" targetFramework="net472" />
  <package id="System.Security.Cryptography.ProtectedData" version="7.0.0" targetFramework="net472" />
  <package id="System.Security.Cryptography.X509Certificates" version="4.3.2" targetFramework="net472" />
  <package id="System.Security.Permissions" version="7.0.0" targetFramework="net472" />
  <package id="System.Security.Principal.Windows" version="5.0.0" targetFramework="net472" />
  <package id="System.Text.Encoding" version="4.3.0" targetFramework="net472" />
  <package id="System.Text.Encodings.Web" version="7.0.0" targetFramework="net472" />
  <package id="System.Text.Json" version="7.0.1" targetFramework="net472" />
  <package id="System.Threading.Tasks.Extensions" version="4.5.4" targetFramework="net472" />
  <package id="System.ValueTuple" version="4.5.0" targetFramework="net472" />
</packages>

I understand that this may be out of the scope of this project but it would really appreciate it if you could take a look.

ErikEJ commented 1 year ago

Why are you still creating .NET Framework projects these days?

It can probably be fixed with a binding redirect, but as you say out of scope in this context.