[bug] Database Triggers Cause Exception about sqlcover HOT 4 CLOSED

A fix to this is to alter the query used to populate this data to read inside of DatabaseSourceGateway.cs:

SELECT sm.object_id, ISNULL('[' + OBJECT_SCHEMA_NAME(sm.object_id)+ '].[' + OBJECT_NAME(sm.object_id) + ']','[' + st.name + ']')  object_name, sm.definition, sm.uses_quoted_identifier FROM sys.sql_modules sm LEFT JOIN sys.triggers st ON st.object_id = sm.object_id WHERE sm.object_id NOT IN (SELECT object_id FROM sys.objects WHERE type = 'IF');

I've made a fix for this in my fork of the project:
https://github.com/Azhkanizkael/SQLCover/blob/master/src/SQLCover/SQLCover/Source/DatabaseSourceGateway.cs

from sqlcover.

I am starting to put together the next release, I will include this fix in that release.

Thanks @Azhkanizkael for the fix :)

from sqlcover.

Do you know when we could expect the fix for this issue to be released?

from sqlcover.

This should be included in 0.5.0:

https://github.com/GoEddie/SQLCover/releases/tag/0.5.0

any problems please re-open and let me know

from sqlcover.