[Wix] how to copy SQL scripts to a temporary folder, then delete them after executing them?

Question

.NET

People, tell me. how to implement it. There is a complex logic, when updating one, when installing another. That is, you need to run scripts from the batch file during installation, and when updating, read the version of the latest patch from the database and execute only the necessary scripts, so standard WIX tools are not suitable. I do through CustomAction. I don't understand how this is done at all. I created binaries, how can I use them?
Muddy theme this WIX, it's just tough. Who came up with this...

<Fragment>
    <Binary Id="CreateDbBatFile"
            SourceFile="$(var.DemoDbScriptsFolder)\$(var.SqlBatFileName)" />
    <Binary Id="CreateDbSqlScriptPart1"
            SourceFile="$(var.DemoDbScriptsFolder)\$(var.SqlCreatePart1FileName)" />
    <Binary Id="CreateDbSqlScriptPart2"
            SourceFile="$(var.DemoDbScriptsFolder)\$(var.SqlCreatePart2FileName)" />
  </Fragment>

Answer 1

not use WIX but use WixSharp and CustomActions