Effective data comparison?

Question

SQL

Good afternoon, I recently wrote an application that analyzes an assembly for attributes.
There was a task to save these attributes in base.
Whether a question in that how to check is in base attributes.
As I understand it, the IN operation has some limitations, especially when comparing multiple parameters.
Example: An
attribute of the form [SourceAnnotation("Sam Fisher","08-05-2015")]
Compared in the database 2 parameters because , there can be hundreds of attributes, some are already in the database.
So, is the IN operator applicable for such operations?

Answer 1

There is an option to read the entire table in HashSet<Tuple<string, string>>and then check in the client's memory.