Hi,
I have database table called Tickets. Records are populated into the table by some third party application (So i don't have control over it). Ticket table has following columns
TicketNumber, Date, StartTime, EndTime.
Now I have written windows service in C#. I want to collect records from table when Date and StartTime will match using C#.
I don't want to write a query which will be executed after every 2 min, and will check for match record. I also tried to use Sql Dependancy but couldn't find the solution. I think I also can't write scheduled job because StartTime of the ticket is not same every time. It could be different for other days.
I want efficient solution which will need less number of times Database Connections or Query Execution.
Thanks,
bipin