wpf 不应加载引用程序集以供执行,只能在仅反射加载程序上下文中加载引用程序集

idfiyjo8  于 2023-03-04  发布在  其他
关注(0)|答案(3)|浏览(231)

我有一个与postgresql数据库交互的wpf应用程序，为此我使用Npgsql，测试时一切正常，没有异常，但当我为应用程序创建setup.exe并运行它时，我尝试登录，但它给我这个异常

下面是导致异常的块

private void LoginButton_Click(object sender, RoutedEventArgs e)
        {
            username = user.Text;
            password = pass.Password;

            // Specify connection
            NpgsqlConnection conn = new NpgsqlConnection( // the exception occurs here
                "Server=127.0.0.1;" + // I also tried to set the server url to my pc's ip address on the local network but still the same problem
                "User Id=username;" +
                "Password=password;" +
                "Database=db;" +
                "Port=3500");
            conn.Open();

            // Define a query
            NpgsqlCommand cmd = new NpgsqlCommand($"SELECT resid FROM resaccounts WHERE username = '{username}' and password = '{password}';", conn);

            // Execute a query
            NpgsqlDataReader dr = cmd.ExecuteReader();

            if (dr.Read())
            {
                // Specify connection
                NpgsqlConnection conn2 = new NpgsqlConnection(
                    "Server=127.0.0.1;" +
                    "User Id=adminBakri;" +
                    "Password=snoffi9000bakri6;" +
                    "Database=shobek_lobek_db;" +
                    "Port=3500");
                conn2.Open();

                // Define a query
                NpgsqlCommand cmd2 = new NpgsqlCommand($"SELECT name FROM restaurants WHERE id = {(int)dr[0]};", conn2);

                // Execute a query
                NpgsqlDataReader dr2 = cmd2.ExecuteReader();

                if (dr2.Read())
                {
                    try
                    {
                        Properties.Settings.Default.UserName = Encrypt(username);
                        Properties.Settings.Default.UserPassword = Encrypt(password);
                        Properties.Settings.Default.ResId = (int)dr[0];
                        Properties.Settings.Default.ResName = dr2[0].ToString();
                        Properties.Settings.Default.Save();
                    }
                    catch (Exception exp)
                    {
                        Console.WriteLine(exp);
                    }

                    this.Hide();
                    Window mainWindow = new MainWindow();
                    mainWindow.Show();
                    this.Close();
                }

                conn2.Close();
            }
            else
            {
                Console.WriteLine("Error, Wrong info");
            }

            // Close connection
            conn.Close();

        }

我还有所有nuget包的最新版本，包括System.ValueTuple和Npgsql。
我按照此tutorial中的步骤为我的应用程序创建了setup.exe，我不知道问题出在哪里
请帮帮我，谢谢。

**编辑：**附加信息：我没有使用MVVM
编辑：添加有关如何创建SETUP.EXE的步骤

第1步：我在解决方案中添加了一个安装项目。
第二步：我有以下文件夹。

第三步：我在前两个文件夹中添加了以下内容。

到目前为止，我有以下内容：

在应用程序文件夹中：

在Program Files文件夹中：

第4步：我在Program Files文件夹中创建了该文件的快捷方式，并将其添加到用户桌面和用户程序菜单文件夹中

第五步：我把所有文件夹的AlwaysCreate属性值设置为True。

第6步：我现在所做的是重新构建解决方案和重新构建安装项目，然后我进入安装项目的debug文件夹并从setup.msi安装应用程序。

这是我的.csproj文件：

<?xml version="1.0" encoding="utf-8"?>
<Project ToolsVersion="15.0" xmlns="http://schemas.microsoft.com/developer/msbuild/2003">
  <Import Project="$(MSBuildExtensionsPath)\$(MSBuildToolsVersion)\Microsoft.Common.props" Condition="Exists('$(MSBuildExtensionsPath)\$(MSBuildToolsVersion)\Microsoft.Common.props')" />
  <PropertyGroup>
    <Configuration Condition=" '$(Configuration)' == '' ">Debug</Configuration>
    <Platform Condition=" '$(Platform)' == '' ">AnyCPU</Platform>
    <ProjectGuid>{F2571E19-BB3A-46FA-B1A1-15ECD9392887}</ProjectGuid>
    <OutputType>WinExe</OutputType>
    <RootNamespace>Food_Ordering_Res</RootNamespace>
    <AssemblyName>Restaurants Helper</AssemblyName>
    <TargetFrameworkVersion>v4.8</TargetFrameworkVersion>
    <TargetPlatformVersion>10.0.10240.0</TargetPlatformVersion>
    <LangVersion>8.0</LangVersion>
    <FileAlignment>512</FileAlignment>
    <ProjectTypeGuids>{60dc8134-eba5-43b8-bcc9-bb4bc16c2548};{FAE04EC0-301F-11D3-BF4B-00C04F79EFBC}</ProjectTypeGuids>
    <WarningLevel>4</WarningLevel>
    <AutoGenerateBindingRedirects>true</AutoGenerateBindingRedirects>
    <TargetFrameworkProfile />
    <NuGetPackageImportStamp>
    </NuGetPackageImportStamp>
  </PropertyGroup>
  <PropertyGroup Condition=" '$(Configuration)|$(Platform)' == 'Debug|AnyCPU' ">
    <PlatformTarget>AnyCPU</PlatformTarget>
    <DebugSymbols>true</DebugSymbols>
    <DebugType>full</DebugType>
    <Optimize>false</Optimize>
    <OutputPath>bin\Debug\</OutputPath>
    <DefineConstants>DEBUG;TRACE</DefineConstants>
    <ErrorReport>prompt</ErrorReport>
    <WarningLevel>4</WarningLevel>
    <Prefer32Bit>false</Prefer32Bit>
  </PropertyGroup>
  <PropertyGroup Condition=" '$(Configuration)|$(Platform)' == 'Release|AnyCPU' ">
    <PlatformTarget>AnyCPU</PlatformTarget>
    <DebugType>pdbonly</DebugType>
    <Optimize>true</Optimize>
    <OutputPath>bin\Release\</OutputPath>
    <DefineConstants>TRACE</DefineConstants>
    <ErrorReport>prompt</ErrorReport>
    <WarningLevel>4</WarningLevel>
    <Prefer32Bit>false</Prefer32Bit>
  </PropertyGroup>
  <PropertyGroup />
  <PropertyGroup />
  <PropertyGroup>
    <ApplicationIcon>main_logo2_qAL_icon.ico</ApplicationIcon>
  </PropertyGroup>
  <PropertyGroup>
    <StartupObject>Food_Ordering_Res.App</StartupObject>
  </PropertyGroup>
  <ItemGroup>
    <Reference Include="System" />
    <Reference Include="System.Data" />
    <Reference Include="System.Numerics" />
    <Reference Include="System.Xml" />
    <Reference Include="Microsoft.CSharp" />
    <Reference Include="System.Core" />
    <Reference Include="System.Xml.Linq" />
    <Reference Include="System.Data.DataSetExtensions" />
    <Reference Include="System.Net.Http" />
    <Reference Include="System.Xaml">
      <RequiredTargetFramework>4.0</RequiredTargetFramework>
    </Reference>
    <Reference Include="WindowsBase" />
    <Reference Include="PresentationCore" />
    <Reference Include="PresentationFramework" />
  </ItemGroup>
  <ItemGroup>
    <ApplicationDefinition Include="App.xaml">
      <Generator>MSBuild:Compile</Generator>
      <SubType>Designer</SubType>
    </ApplicationDefinition>
    <Compile Include="ConfirmLogOut.xaml.cs">
      <DependentUpon>ConfirmLogOut.xaml</DependentUpon>
    </Compile>
    <Compile Include="IncomeInfoWindow.xaml.cs">
      <DependentUpon>IncomeInfoWindow.xaml</DependentUpon>
    </Compile>
    <Compile Include="Login.xaml.cs">
      <DependentUpon>Login.xaml</DependentUpon>
    </Compile>
    <Compile Include="MealEditWindow.xaml.cs">
      <DependentUpon>MealEditWindow.xaml</DependentUpon>
    </Compile>
    <Compile Include="NotificationService.cs" />
    <Compile Include="OfflineMealAdditionInfoWindow.xaml.cs">
      <DependentUpon>OfflineMealAdditionInfoWindow.xaml</DependentUpon>
    </Compile>
    <Compile Include="RelayCommand.cs" />
    <Compile Include="Splash.xaml.cs">
      <DependentUpon>Splash.xaml</DependentUpon>
    </Compile>
    <Compile Include="UserControlAddCategory.xaml.cs">
      <DependentUpon>UserControlAddCategory.xaml</DependentUpon>
    </Compile>
    <Compile Include="UserControlAddMeal.xaml.cs">
      <DependentUpon>UserControlAddMeal.xaml</DependentUpon>
    </Compile>
    <Compile Include="UserControlCheckBalance.xaml.cs">
      <DependentUpon>UserControlCheckBalance.xaml</DependentUpon>
    </Compile>
    <Compile Include="UserControlEditMeal.xaml.cs">
      <DependentUpon>UserControlEditMeal.xaml</DependentUpon>
    </Compile>
    <Compile Include="UserControlExpenses.xaml.cs">
      <DependentUpon>UserControlExpenses.xaml</DependentUpon>
    </Compile>
    <Compile Include="UserControlHome.xaml.cs">
      <DependentUpon>UserControlHome.xaml</DependentUpon>
    </Compile>
    <Compile Include="UserControlOfflineMealAddition.xaml.cs">
      <DependentUpon>UserControlOfflineMealAddition.xaml</DependentUpon>
    </Compile>
    <Page Include="ConfirmLogOut.xaml">
      <SubType>Designer</SubType>
      <Generator>MSBuild:Compile</Generator>
    </Page>
    <Page Include="IncomeInfoWindow.xaml">
      <SubType>Designer</SubType>
      <Generator>MSBuild:Compile</Generator>
    </Page>
    <Page Include="Login.xaml">
      <SubType>Designer</SubType>
      <Generator>MSBuild:Compile</Generator>
    </Page>
    <Page Include="MainWindow.xaml">
      <Generator>MSBuild:Compile</Generator>
      <SubType>Designer</SubType>
    </Page>
    <Compile Include="App.xaml.cs">
      <DependentUpon>App.xaml</DependentUpon>
      <SubType>Code</SubType>
    </Compile>
    <Compile Include="MainWindow.xaml.cs">
      <DependentUpon>MainWindow.xaml</DependentUpon>
      <SubType>Code</SubType>
    </Compile>
    <Page Include="MealEditWindow.xaml">
      <SubType>Designer</SubType>
      <Generator>MSBuild:Compile</Generator>
    </Page>
    <Page Include="OfflineMealAdditionInfoWindow.xaml">
      <SubType>Designer</SubType>
      <Generator>MSBuild:Compile</Generator>
    </Page>
    <Page Include="Splash.xaml">
      <SubType>Designer</SubType>
      <Generator>MSBuild:Compile</Generator>
    </Page>
    <Page Include="UserControlAddCategory.xaml">
      <SubType>Designer</SubType>
      <Generator>MSBuild:Compile</Generator>
    </Page>
    <Page Include="UserControlAddMeal.xaml">
      <SubType>Designer</SubType>
      <Generator>MSBuild:Compile</Generator>
    </Page>
    <Page Include="UserControlCheckBalance.xaml">
      <SubType>Designer</SubType>
      <Generator>MSBuild:Compile</Generator>
    </Page>
    <Page Include="UserControlEditMeal.xaml">
      <SubType>Designer</SubType>
      <Generator>MSBuild:Compile</Generator>
    </Page>
    <Page Include="UserControlExpenses.xaml">
      <SubType>Designer</SubType>
      <Generator>MSBuild:Compile</Generator>
    </Page>
    <Page Include="UserControlHome.xaml">
      <SubType>Designer</SubType>
      <Generator>MSBuild:Compile</Generator>
    </Page>
    <Page Include="UserControlOfflineMealAddition.xaml">
      <SubType>Designer</SubType>
      <Generator>MSBuild:Compile</Generator>
    </Page>
  </ItemGroup>
  <ItemGroup>
    <Compile Include="Properties\AssemblyInfo.cs">
      <SubType>Code</SubType>
    </Compile>
    <Compile Include="Properties\Resources.Designer.cs">
      <AutoGen>True</AutoGen>
      <DesignTime>True</DesignTime>
      <DependentUpon>Resources.resx</DependentUpon>
    </Compile>
    <Compile Include="Properties\Settings.Designer.cs">
      <AutoGen>True</AutoGen>
      <DependentUpon>Settings.settings</DependentUpon>
      <DesignTimeSharedInput>True</DesignTimeSharedInput>
    </Compile>
    <Resource Include="main_logo2_qAL_icon.ico" />
    <EmbeddedResource Include="Properties\Resources.resx">
      <Generator>ResXFileCodeGenerator</Generator>
      <LastGenOutput>Resources.Designer.cs</LastGenOutput>
    </EmbeddedResource>
    <Resource Include="Assets\home.png" />
    <Resource Include="Assets\1.png" />
    <Resource Include="Assets\2.png" />
    <Resource Include="Assets\3.png" />
    <Resource Include="Assets\4.png" />
    <Content Include="Fonts\ae_Dimnah.ttf">
      <CopyToOutputDirectory>Always</CopyToOutputDirectory>
    </Content>
    <None Include="Properties\Settings.settings">
      <Generator>SettingsSingleFileGenerator</Generator>
      <LastGenOutput>Settings.Designer.cs</LastGenOutput>
    </None>
  </ItemGroup>
  <ItemGroup>
    <None Include="App.config" />
  </ItemGroup>
  <ItemGroup>
    <PackageReference Include="LoadingIndicators.WPF">
      <Version>0.0.1</Version>
    </PackageReference>
    <PackageReference Include="MaterialDesignColors">
      <Version>1.1.2</Version>
    </PackageReference>
    <PackageReference Include="MaterialDesignThemes">
      <Version>2.3.1.953</Version>
    </PackageReference>
    <PackageReference Include="Microsoft.Bcl.AsyncInterfaces">
      <Version>1.1.0</Version>
    </PackageReference>
    <PackageReference Include="Microsoft.Windows.SDK.Contracts">
      <Version>10.0.18362.2005</Version>
    </PackageReference>
    <PackageReference Include="Newtonsoft.Json">
      <Version>12.0.3</Version>
    </PackageReference>
    <PackageReference Include="Npgsql">
      <Version>4.1.3.1</Version>
    </PackageReference>
    <PackageReference Include="Portable.BouncyCastle">
      <Version>1.8.6.7</Version>
    </PackageReference>
    <PackageReference Include="RestSharp">
      <Version>106.10.1</Version>
    </PackageReference>
    <PackageReference Include="System.Buffers">
      <Version>4.5.1</Version>
    </PackageReference>
    <PackageReference Include="System.Memory">
      <Version>4.5.4</Version>
    </PackageReference>
    <PackageReference Include="System.Numerics.Vectors">
      <Version>4.5.0</Version>
    </PackageReference>
    <PackageReference Include="System.Runtime.CompilerServices.Unsafe">
      <Version>4.7.1</Version>
    </PackageReference>
    <PackageReference Include="System.Runtime.WindowsRuntime">
      <Version>4.7.0</Version>
    </PackageReference>
    <PackageReference Include="System.Runtime.WindowsRuntime.UI.Xaml">
      <Version>4.7.0</Version>
    </PackageReference>
    <PackageReference Include="System.Text.Encodings.Web">
      <Version>4.7.0</Version>
    </PackageReference>
    <PackageReference Include="System.Text.Json">
      <Version>4.7.1</Version>
    </PackageReference>
    <PackageReference Include="System.Threading.Tasks.Extensions">
      <Version>4.5.4</Version>
    </PackageReference>
    <PackageReference Include="System.ValueTuple">
      <Version>4.5.0</Version>
    </PackageReference>
  </ItemGroup>
  <Import Project="$(MSBuildToolsPath)\Microsoft.CSharp.targets" />
</Project>
wpf

3条答案

按热度按时间
kokeuurv

kokeuurv1#

您的csproj文件针对的是.NET Framework v 4.8，该版本已内置System.ValueTuple。我怀疑内置版本与您要添加为Nuget包的版本之间存在冲突。
只需删除System.ValueTuple的PackageReference（删除Nuget包）并重新构建就可以了，您的代码中可能也需要删除一些“using”引用。

赞(0）分享  回复(0）举报  2023-03-04
nwnhqdif

nwnhqdif2#

这似乎是一个解决问题的长期方案，但根据Dean的说法，您应该尝试创建一个新项目，并将目标框架设置为.Net Framework 4.6.1，然后将旧项目中的所有文件复制到新项目中，然后重新尝试所有操作。
希望这能解决你的问题。

赞(0）分享  回复(0）举报  2023-03-04
8ljdwjyq

8ljdwjyq3#

我在使用“System.Numerics.Vectors.dll”时也遇到了同样的问题，上面的解决方案对我都不起作用。

Microsoft.Graph.ServiceException: Code: generalException
Message: An error occurred sending the request.
 ---> System.BadImageFormatException: Could not load file or assembly 'System.Numerics.Vectors, Version=4.1.4.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. Reference assemblies should not be loaded for execution.  They can only be loaded in the Reflection-only loader context. (Exception from HRESULT: 0x80131058) ---> System.BadImageFormatException: Cannot load a reference assembly for execution.

Visual Studio中的警告：

Warning     Found conflicts between different versions of "System.Numerics.Vectors" that could not be resolved.
There was a conflict between "System.Numerics.Vectors, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" and "System.Numerics.Vectors, Version=4.1.4.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a".
    "System.Numerics.Vectors, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" was chosen because it was primary and "System.Numerics.Vectors, Version=4.1.4.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" was not.

我试过：
1.将程序集版本同时更改为32和64
1.正在App.config中添加程序集绑定：

<runtime>
    <assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">
        <dependentAssembly>
            <assemblyIdentity name="System.Numerics.Vectors"
                              publicKeyToken="b03f5f7f11d50a3a"
                              culture="neutral" />

            <bindingRedirect oldVersion="0.0.0.0-4.1.4.0" newVersion="4.1.4.0" />
        </dependentAssembly>
    </assemblyBinding>
</runtime>

1.将.Net框架版本从4.7.2更改为4.6.2、4.8
1.正在完全删除应用程序配置文件
1.清理、重建并删除bin、obj文件夹等。
调试应用程序，甚至运行exe都运行得很好。
最后，我意识到4.0.0.0GAC中只存在“System.Numerics.Vectors.dll”的www.example.com版本，而缺少4.1.4.0版本（我使用ildasm.exe查找dll的程序集版本）。
然后解决方案是使用gacutil -i fullPathOfDll安装丢失的版本dll。而且成功了！

赞(0）分享  回复(0）举报  2023-03-04
我来回答

相关问题

    查看更多

    热门标签

    更多
    JavaquerypythonNode开发语言requestUtil数据库Table后端算法LoggerMessageElementParser

    最新问答

    更多
    • 蜀ICP备2022004421号-2 NULL123 https://www.null123.com © All rights reserved
    • 本站内容来源互联网,如果侵犯您的权益请联系我们删除, 联系方式：448109455@qq.com