SQLite 的相对路径不适用于 WIX 工具集 [英] Relative path for SQLite not working with WIX Toolset

问题描述

我正在使用 SQLite 数据库并使用 WIX 工具集创建 WPF 应用程序的安装程序.问题是，当我直接从 Visual Studio 运行时，下面的相对路径可以正常工作，但当我使用 WIX 创建安装程序并且安装此安装程序运行程序后，它会为数据库文件提供致命错误.在项目目录中，我创建了一个数据库文件夹，数据库文件位于其中，如下图所示:

I'm using SQLite Database and create installer of WPF application with WIX Toolset. The problem is, The below relative path works fine when I directly run from Visual Studio but does not work when I create installer with WIX and after install this installer run program then it gives fatal error for Database file. In Project directory I've made a Database folder, in which the database files reside as you can see in below picture:

通过 WIX Toolset 创建安装程序后，安装文件如下:

After creating installer by WIX Toolset, installed files as below:

inventory_control.db 文件路径:

inventory_control.db file path:

dbConnectionString 路径:

dbConnectionString path:

我已经为相对路径连接字符串编写了如下代码:

I've writen code for relative path connection string as under:

相对路径:

  string relativePath = @"Databaseinventory_control.db";
        string currentPath = System.Reflection.Assembly.GetExecutingAssembly().Location;
        //string path = currentPath.Substring(0, currentPath.Length - 21);
        string path = Path.GetDirectoryName(currentPath);
        string absolutePath = System.IO.Path.Combine(path, relativePath);
        string dbConnectionString = string.Format("Data Source={0};Version=3;Pooling=True;Max Pool Size=100;", absolutePath);

        //string dbConnectionString = "Data Source=inventory_control.db";
        sQLiteConnection = new SQLiteConnection(dbConnectionString);

dbConnectionString 给出正确的当前路径.当我直接从 Visual Studio 运行时，上面的相对路径工作正常，但当我使用 WIX 创建安装程序时不起作用.它给出了一个致命的错误.如何解决?

dbConnectionString gives correct current path. The above relative path works fine when I directly run from Visual Studio but does not work when I create installer with WIX. It gives a fatal error. How to resolve?

WIX 文件:

<?xml version="1.0" encoding="UTF-8"?>
<Wix xmlns="http://schemas.microsoft.com/wix/2006/wi"><?define Inventory Control_TargetDir=$(var.Inventory Control.TargetDir)?>
    <Product Id="f941ba49-4369-44d4-aa0c-b77f20aa41db" Name="Inventory Control" Language="1033" Version="1.0.0.0" Manufacturer="devtros.com" UpgradeCode="ce092371-53cc-4be9-ab5d-c7a2685af970">
        <Package InstallerVersion="200" Compressed="yes" InstallScope="perMachine" />

    <Icon Id="app_icon.ico" SourceFile="$(var.ProjectDir)app_icon.ico" />
    <Property Id="ARPPRODUCTION" Value="app_icon.ico" />

    <WixVariable Id="WixUIBannerBmp" Value="Imagesackground.bmp" />
    <WixVariable Id="WixUIDialogBmp" Value="Imagesackground.bmp" />
    <WixVariable Id="WixUILicenseRtf" Value="$(var.ProjectDir)License.rtf" />

    <Property Id="WIXUI_INSTALLDIR" Value="INSTALLFOLDER" />
    <UIRef Id="WixUI_InstallDir" />

        <MajorUpgrade DowngradeErrorMessage="A newer version of [ProductName] is already installed." />
        <MediaTemplate EmbedCab="yes" />

        <Feature Id="ProductFeature" Title="Inventory Control" Level="1">
            <ComponentGroupRef Id="ProductComponents" />
      <ComponentRef Id="ApplicationShortcut" />
      <ComponentRef Id="ApplicationShortcutDesktop" />
            <ComponentGroupRef Id="Database_files" />
        </Feature>
    </Product>

    <Fragment>
        <Directory Id="TARGETDIR" Name="SourceDir">
            <Directory Id="ProgramFilesFolder">
        <Directory Id="INSTALLFOLDER" Name="Inventory Control">
          <Directory Id="Files" Name="Files" />
          <Directory Id="Database" Name="Database" />
        </Directory>
            </Directory>
      <Directory Id="ProgramMenuFolder">
        <Directory Id="ApplicationProgramsFolder" Name="Inventory Control" />
      </Directory>
      <Directory Id="DesktopFolder" Name="Desktop" />
        </Directory>
    </Fragment>

  <Fragment>
    <DirectoryRef Id="ApplicationProgramsFolder">
      <Component Id="ApplicationShortcut" Guid="9bd13330-6540-406f-a3a8-d7f7c69ae7f9">
        <Shortcut Id="ApplicationStartMenuShortcut" Name="Inventory Control" Description="Inventory Control" Target="[INSTALLFOLDER]Inventory Control.exe" WorkingDirectory="INSTALLFOLDER" />
        <RemoveFolder Id="RemoveApplicationProgramsFolder" Directory="ApplicationProgramsFolder" On="uninstall" />
        <RegistryValue Root="HKCU" Key="SoftwareInventory Control" Name="installed" Type="integer" Value="1" KeyPath="yes" />
      </Component>
    </DirectoryRef>
    <DirectoryRef Id="DesktopFolder">
      <Component Id="ApplicationShortcutDesktop" Guid="cde1e030-eb64-49a5-b7b8-400b379c2d1a">
        <Shortcut Id="ApplicationDesktopShortcut" Name="Inventory Control" Description="Inventory Control" Target="[INSTALLFOLDER]Inventory Control.exe" WorkingDirectory="INSTALLFOLDER" />
        <RemoveFolder Id="RemoveDesktopFolder" Directory="DesktopFolder" On="uninstall" />
        <RegistryValue Root="HKCU" Key="SoftwareInventory Control" Name="installed" Type="integer" Value="1" KeyPath="yes" />
      </Component>
    </DirectoryRef>
  </Fragment>

    <Fragment>
        <ComponentGroup Id="ProductComponents" Directory="INSTALLFOLDER">
            <!-- TODO: Remove the comments around this Component element and the ComponentRef below in order to add resources to this installer. -->
            <!-- <Component Id="ProductComponent"> -->
                <!-- TODO: Insert files, registry keys, and other resources here. -->
            <!-- </Component> -->
            <Component Id="Inventory_Control.exe" Guid="0a7e7061-201b-4d49-adeb-4449e9c4da3e">
              <File Id="Inventory_Control.exe" Name="Inventory Control.exe" Source="$(var.Inventory Control_TargetDir)Inventory Control.exe" />
            </Component>
            <Component Id="Inventory_Control.exe.config" Guid="28323615-8159-4116-b1ac-e29a70bf2593">
              <File Id="Inventory_Control.exe.config" Name="Inventory Control.exe.config" Source="$(var.Inventory Control_TargetDir)Inventory Control.exe.config" />
            </Component>
            <Component Id="System.Windows.Controls.Input.Toolkit.dll" Guid="7d678201-767a-416b-b645-b2cb7d514893">
              <File Id="System.Windows.Controls.Input.Toolkit.dll" Name="System.Windows.Controls.Input.Toolkit.dll" Source="$(var.Inventory Control_TargetDir)System.Windows.Controls.Input.Toolkit.dll" />
            </Component>
            <Component Id="System.Data.SQLite.dll" Guid="178a5aef-c027-4215-81ae-f148ab6cd472">
              <File Id="System.Data.SQLite.dll" Name="System.Data.SQLite.dll" Source="$(var.Inventory Control_TargetDir)System.Data.SQLite.dll" />
            </Component>
            <Component Id="Zen.Barcode.Core.dll" Guid="20e34fc3-0066-4ffd-b401-518bc1177098">
              <File Id="Zen.Barcode.Core.dll" Name="Zen.Barcode.Core.dll" Source="$(var.Inventory Control_TargetDir)Zen.Barcode.Core.dll" />
            </Component>
            <Component Id="WPFToolkit.dll" Guid="8d974e65-defb-4675-b9e0-ff617e5ab1da">
              <File Id="WPFToolkit.dll" Name="WPFToolkit.dll" Source="$(var.Inventory Control_TargetDir)WPFToolkit.dll" />
            </Component>
        </ComponentGroup>
    </Fragment>

  <Fragment>
    <ComponentGroup Id="Database_files" Directory="Database">
      <Component Id="Database_inventory_control.db" Guid="0104b919-0aa9-4dc5-9492-14c474d97cf1">
        <File Id="Database_inventory_control.db" Name="inventory_control.db" Source="$(var.Inventory Control_TargetDir)Databaseinventory_control.db" />
      </Component>
    </ComponentGroup>
  </Fragment>
</Wix>

推荐答案

SQLite.Interop.dll:文件 SQLite.Interop.dll 需要与其他运行时文件一起安装在SQLite 的订单正常运行.

SQLite.Interop.dll: The file SQLite.Interop.dll needed to be installed along with the rest of the runtime files in order for SQLite to function properly.

文件有两种风格，x86 和 x64 格式.它是可能建议将这两个文件安装在各自的文件夹中:

There are two flavors of the file, x86 and x64 format. It is probably advisable to install both files in their respective folders:

您的安装文件夹层次结构 - 模型:

Your installation folder hierarchy - mock-up:

• YourBinary.exe
• x86SQLite.Interop.dll
• x64SQLite.Interop.dll
• System.Data.SQLite.dll
• 等等...

读写数据库位置:然后您的数据库应存储在可写路径中(或者您需要使用自定义 ACL 权限使该路径对普通用户可写- 这绝不是一个好主意).

Read-Write DB Location: And then your database should be stored in a writeable path (or you need to make the path writeable for regular users using custom ACL permissioning - which is never a great idea).

异常:显然try - catch您的数据库连接、更新和访问代码以检测此类问题.

Exceptions: Obviously try - catch your database connection, update and access code to detect these kinds of issues.

<小时>

1. 文件夹混乱:数据库文件夹中是否有数据库文件?有点像 inventory_control.db 文件安装到主应用程序文件夹，而不是 Database 子文件夹?

• 也许该文件是由 application.exe 在错误文件夹中生成的?
• 或者您可能出于测试目的复制了主文件夹中的文件?

• Maybe that file has been generated by the application.exe in the wrong folder?
• Or maybe you have duplicated the file in the main folder for testing purposes?

Hard-Coded Dev-Box Sins?:在 Inventory Control.exe.config 中说明了什么?

Hard-Coded Dev-Box Sins?: What does it say in Inventory Control.exe.config?

• 其中是否有可以覆盖您代码值的相关设置?
• 里面会不会有硬编码的 dev-box 罪过?

路径生成器:我假设您在启动期间已将来自应用程序的路径装箱"，以确保它们是正确的?我喜欢复制路径并执行 Start =>运行 并粘贴路径以查看它是否打开.显示消息框时按 CTRL + C.粘贴到记事本中.提取路径并在 Start => 中尝试运行.

Path Builder: I assume you have "message boxed" the paths from the application during launch, in order to ensure that they are correct? I like to copy the path and do a Start => Run and paste the path to see that it opens. Press CTRL + C when the message box shows. Paste into Notepad. Extract the path and try it in Start => Run.

• 字符串路径 = currentPath.Substring(0, currentPath.Length - 21);.硬编码文件名中的字符数来获取父目录路径是不是很健壮?
• 您能否使用 Path.GetDirectoryName(currentPath) 对其进行改进?
• 甚至可能:string dir = currentPath.Substring(0,currentPath.LastIndexOf('\'));

• string path = currentPath.Substring(0, currentPath.Length - 21);. It is not very robust to hard code the number of characters in the file name to get the parent directory path?
• Could you improve it by using Path.GetDirectoryName(currentPath)?
• Or maybe even: string dir = currentPath.Substring(0,currentPath.LastIndexOf('\'));

附加调试器 &调试二进制文件?:也许您可以安装调试二进制文件并附加到它们以进行调试，如下所述:wix c# 应用在安装后无法启动.只是为了获得真正的逐步调试会话.

Attach Debugger & Debug Binaries?: Maybe you could install debug binaries and attach to them for debugging as described here: wix c# app doesn't launch after installing. Just to get a real step-through debugging session.

路径空间:数据库连接字符串.它的路径是否需要引号?如带空格的路径"?您的 Visual Studio 项目的路径中可能没有任何空格，但安装时路径中有空格.

Path Spaces: That database connection string. Does it need quotes around its path? As in "path with spaces"? You may not have any spaces in the paths for your visual Studio project, but when installed there are spaces in the paths.

<小时>

你源代码中的这个结构看起来很奇怪，为什么有必要?:

---

This constructs in your source does look weird, why is it necessary?:

• <?define Inventory Control_TargetDir=$(var.Inventory Control.TargetDir)?>

这篇关于SQLite 的相对路径不适用于 WIX 工具集的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！