Fix S3966 FN: Support Close() method

[mary-georgiou-sonarsource]

S3966

Sometimes Close is disposing of resources (like in the case of streams) and sometimes not (like in the case of DBConnection).

Detect Close only for a well-known list of types where we know that the behavior is equivalent to Dispose - like streams - and raise an issue.