DapperLib / DapperAOT

Build time tools in the flavor of Dapper
Other
349 stars 19 forks source link

DAP231 fires for table-valued functions #120

Open jnm2 opened 1 month ago

jnm2 commented 1 month ago

"⚠️ DAP231 SELECT for single row without WHERE or (TOP and ORDER BY)" is firing for fn_listextendedproperty.

When the table-valued function has parameters, it's less likely that filtering is not happening.

return await connection.QuerySingleAsync<int?>(
    "select value from sys.fn_listextendedproperty('DatabaseLevelExtendedPropName', null, null, null, null, null, null)");