Add ability to update current rules or bring your own

[ErikEJ]

I now find myself fixing bugs to the SqlServer.Rules rule set and having a mechanism to update the ruleset out of band with a SDK update would be handy.

I am proposing the following simple approach, but let me hear what anyone else thinks.

• Allow .dll content files to be added to the output folder actually need this path, not available today
• Update DacpacTool: If CodeAnalysis is enabled, copy any .dll files from the output folder to the folder of executing assembly
• DacFX Code Analysis will automagically pick up the added / updated rules

Sample .csproj addition to copy .dll files the output folder

    <ItemGroup>
      <None Update="SqlServer.Dac.dll">
        <CopyToOutputDirectory>Always</CopyToOutputDirectory>
      </None>
      <None Update="SqlServer.Rules.dll">
        <CopyToOutputDirectory>Always</CopyToOutputDirectory>
      </None>
    </ItemGroup>

[ErikEJ]

@jeffrosenberg @jmezach @tcartwright

[ErikEJ]

I did a POC, I think there are two issues;

Options.Output does not point to the bin folder.

Maybe the file copy of the .dll file happens too late.

[ErikEJ]

@jmezach Sorry to bother you, but is a 2.7.1 release possible?

[jmezach]

@ErikEJ Sure thing, unfortunately I was out sick a couple of days. But I'm back now, so I'll try to get a new release out today.

[jmezach]

@ErikEJ Version 2.7.1 is out now

[ErikEJ]

Wonderful thanks!