Access to the database every 1 hour C#

Question

I have a problem, I'm trying to create a service to connect to an API that I have created.

This service has to connect to a database in Mysql every hour, and see if there is a certain value.

For example every time I'll see if the field x has the value y. If is true, will have to run something.

I already read some things about Threads and System.Threading.Timer, but do not quite understand, can someone give me practical example or the right way to do it, of what I'm looking for, please?

Thanks in advance ..

score 7 · Accepted Answer · edited May 23 '17 at 12:24

7

Create a simple program that does what you need and run it as a windows task which runs each hour.

edited May 23 '17 at 12:24

Community

1
1

answered Apr 29 '13 at 09:07

CloudyMarble

36,908
70
97
130

Agreed. A service may be overkill for this situation. Windows task is likely a better approach. – Simon Apr 29 '13 at 09:11

Newton Sheikh · Answer 2 · 2013-04-29T09:13:46.223

Create an windows service and give it a time interval of 1 hr. This windows service will always be running but will fire the query to database at the assigned interval. with windows service you dont have to mess with threads and all.

partial class YourService : ServiceBase
{
    Timer timer = new Timer();
    ...
    ...


    public YourService()
    { 
        InitializeComponent();
    }

    /// <summary>
    /// 

    protected override void OnStart(string[] args)
    {
        timer.Interval = 1000000; /*The interval of the Windows Service Cycle set this to one hour*/
        timer.Start();
        timer.Enabled = true;
        timer.AutoReset = true;
        timer.Elapsed += new ElapsedEventHandler(OnElapseTime); /*fire the event after each cycle*/
    }

    private void OnElapseTime(object sender, ElapsedEventArgs e)
    {
         // HERE DO UR DATABASE QUERY AND ALL
    }

    ...
    ...
}

score 0 · Answer 3 · answered Apr 29 '13 at 09:14

Create a windows service and move it to the server that you are having the application. This windows service will run 24 hours a day and will do your requirement.

class Program : ServiceBase { System.Timers.Timer timer;

    static void Main(string[] args)
    {
        ServiceBase.Run(new Program());
    }
    public Program()
    {
        this.ServiceName = "DB Sync";
    }
    protected override void OnStart(string[] args)
    {
        base.OnStart(args);
        InitializeTimer();

    }

    protected override void OnStop()
    {
        base.OnStop();

    }

    protected void InitializeTimer()
    {
        try
        {
            if (timer == null)
            {
                timer = new System.Timers.Timer();
                timer.Enabled = true;
                timer.AutoReset = true;
                timer.Interval = 60000 * 1;
                timer.Enabled = true;
                timer.Elapsed += timer_Elapsed;
            }

        }
        catch (Exception ex)
        {

        }
        finally
        {
        }
    }

    protected void timer_Elapsed(object source, System.Timers.ElapsedEventArgs e)
    {

        TimerTick();
        timer.Interval = 60000 * Convert.ToDouble(ConfigurationManager.AppSettings["TimerInerval"]);
    }

    private void TimerTick()
    {
        try
        {
           // Query the DB in this place.
        }
        catch (Exception ex)
        {

        }
    }
}

Access to the database every 1 hour C#

3 Answers3