Work WindowService and Entity Framework

Question

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’