I have an entity collection that is filled with entities. I want to find the entity in the collection where column1 = x and column2 = y, but there are 6 columns total in the entity, and I don't know the values for the other 4 columns. I know that I can iterate through the collection and compare for each one, but I also know that there must be a better way as Frans is a pretty smart dude. What are some other ways I could find this one?
P.S. I know how to use the Find method from the IBindingList but it only lets me search one property, right?