I am trying to figure out code working for an auto testing as follows:
(in C# code, SQL database used)
1. Check whether database (having credentials) is working fine or down?
2. If working, run a select query in it & check for succesful execution.
3. In any case of failure for above 2 points, automatically send an email to somemone.
Kindly help me out. I think it would be a piece of cake for the experts here.
Thanks a ton