There needs to be a way to select or disable the output clause, maybe a way to see the SQL that it is sending to the server.
My issue is:
I get this error -
Column 'inserted.[CALCULATED COLUMN]' cannot be referenced in the OUTPUT clause because the column definition contains a subquery or references a function that performs user or system data access. A function is assumed by default to perform data access if it is not schemabound. Consider removing the subquery or function from the column definition or removing the column from the OUTPUT clause.
Even though I am not updating that caluclated column.
this is recreatable in SQL Server Manager by adding this clause to a standard update query-
OUTPUT inserted.[CALCULATED COLUMN]
I'm able to pull data fine. I am able to update fine when there isn't that calculated column... but our tables have columns, some of which are calculated. This application should have the ability to handle those tables too.