Hi..
I want to work in window service with entity framework this is my following task please describe how can we work?
Create a DB table (in local system) with columns
AlertId (numeric, not unique)
NextDue (DateTime)
Enabled (char, default value ‘Y’)
Status (varchar, default value ‘due’)
Errordesc(varchar)
Create a windows service to query this table every X minutes.
Use Entity Framework to query the table.
If a record is found to be due, update the Status column as
‘Sent’ if Enabled is ‘Y’
‘Disabled’ if Enabled is ‘N’