Edit a msi database table

Question

how can i add or delete entry of a msi database table using msidb.exe rather than using the orca.Is there any commandline like below

msidb.exe [msipath][importingFilepath]

Once the file is added the corresponding entries in the msi tables should be updated

Thanks,

Answer 1

I'll assume you want to do this in C# since you included the C# tag. WiX has a component called Deployment Tools Foundation (DTF - you'll find and SDK chm in the start menu ) that provides an excellent MSI interop.

Consider this:

using Microsoft.Deployment.WindowsInstaller;

namespace ConsoleApplication1
{
    class Program
    {
        static void Main(string[] args)
        {
            using( var database = new Database(@"C:\test.msi", DatabaseOpenMode.Direct))
            {
            }
        }
    }
}

That gives you the starting point to do anything you want to the database via SQL queries.