I cannot have a straight invalidate on the entire "Products" table though, I need to be able to invalidate a selection on the table. The problem I'm having is the following code does not ever invalidate the cache when the data is changed:

Thanks for the tip. I updated the SELECT statement, but the problem still exists where the cache is not invalidated even if something in the table (and the SELECT statement) changes.
–
Greg SniderJan 9 '12 at 17:51

Ah, maybe try adding specific columns that do change to the select statement. I am a little unclear on exactly how the underlying mechanism works, but it may be watching columns in the select statement itself.
–
competent_techJan 9 '12 at 17:53

I updated the opening post with the current code. Changed this line: ocom.CommandText = "SELECT ID,ClinicID,Price,Enabled FROM dbo.Products WHERE ClinicID = 1";
–
Greg SniderJan 9 '12 at 17:53

It still doesn't invalidate the cache even when the SELECT statement looks like it conforms to the requirements.
–
Greg SniderJan 9 '12 at 17:59