c# - 从 C# 插入到 msi 数据库

Question

我正在尝试将一个新属性插入到 msi 文件中。我可以使用以下代码更新 msi 数据库文件。有没有办法将新值添加到表中。我找不到任何东西。

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using WindowsInstaller;

namespace msiExample
{
[System.Runtime.InteropServices.ComImport(), System.Runtime.InteropServices.Guid("000C1090-0000-0000-C000-000000000046")]
class Installer { }
class msiMain
{
    static void Main(string[] args)
    {
     WindowsInstaller.Installer ins = (WindowsInstaller.Installer)new Installer();

            string strFileMsi = @"C:\APP.msi";

           System.Console.WriteLine("STARTING SECOND QUERY");
            Database db2 = ins.OpenDatabase(strFileMsi, WindowsInstaller.MsiOpenDatabaseMode.msiOpenDatabaseModeDirect);
            View vw2 = db2.OpenView(@"Select * FROM Property where Value='Unknown'");  

            vw2.Execute(null);

            Record rcrd2 = vw2.Fetch();
            while (rcrd2 != null)
            {
                System.Console.WriteLine(rcrd2.get_StringData(1));
                rcrd2.set_StringData(1,"No data");
                vw2.Modify(WindowsInstaller.MsiViewModify.msiViewModifyUpdate, rcrd2);

                rcrd2 = vw2.Fetch();

            }               
            db2.Commit();
            vw2.Close();
            System.Console.WriteLine("completed");   
    }
  }
}

Answer 1

Windows Installer XML (WiX) Deployment Tools Foundation (DTF) 库在这方面有很大帮助。我知道最简单的方法是:

using Microsoft.Deployment.WindowsInstaller.Linq;
using (QDatabase database = new QDatabase(@"C:\data\test.msi", DatabaseOpenMode.Direct))
{
  var record = database.Properties.NewRecord();
  record.Property = "MyProperty";
  record.Value = "MyValue";
  record.Insert();
}

如果您仍然想考虑 SQL，那么:

using Microsoft.Deployment.WindowsInstaller;
using (Database database = new Database(@"C:\data\test.msi", DatabaseOpenMode.Direct))
{
  database.Execute("INSERT INTO `Property` (`Property`, `Value`) VALUES('MyProperty', 'MyValue')");
}