How test data in table with Insert new data with use c#

Question

Hi Guys

I need to to test data in the table , is this Exist or not with validations should be appear to users.

also code must be work with high functionality .