jonwagner/Insight.Database.Schema — pull request #11 by msieker (2014-02-19 20:20:51+00:00)
Title: Add support to AutoProc to support tables with triggers

I was trying to put AutoAudit onto the database I'm using Insight on, and SQL started complaining about the OUTPUT statements in the insert/update procs. After some research, I found out that when triggers are involved, the OUTPUT needs to go into a table.

The modification consists of changing Insert/Update/Upsert, both single and bulk versions, to OUTPUT into a table variable that contains the output columns, then selecting from that at the end of the proc. The `outputs` variables were also changed to `IList`s to keep Resharper from complaining about multiple enumeration of `IEnumerable`.

Might be too localized to include in the main line, but I thought I'd send the request along since it could be helpful.