Last post May 27, 2011 12:29 AM by nullableCode
May 26, 2011 09:13 AM|ali_csharp|LINK
I'm going to start a new ASP.NET web application using VS2008/C#, my project is a web-based telemetry, so it should permanently receive data from another soruce, it should access an IP-based SMS URL, fetch sms data and store them in SQL-server database,
so that users can view table/chart reports using these stored (and processed) data. How should I perform this permanent update process? a timer? or something else? is there any sample covering my question? what is the best architecture regarding this scenario?
this update process should be done once a minte and of course it should be done behine the scene, users only view report pages, what are my options?
thanks in advance
May 26, 2011 10:38 AM|bouwob2|LINK
Build a windows service or if you want to go old school and @ job would work just as well.
May 26, 2011 01:09 PM|ali_csharp|LINK
thanks bouwob but what do you mean exactly by old school, is there any classic way? what is a windows service? I couln't find it, there was rather a web service, is it ok? how they are run in a WAP? can I write my update functions in these services? are
there similar to windows service programs?
May 27, 2011 12:29 AM|nullableCode|LINK
a) A windows service with self contained logic that does what you need will ultimately need a manager/scheduler to determine when to fetch the SMS data.. So you will need to build in timers, or event handlers as such if going this path.
b) A windows console application, scheduled using Windows scheduler. Each time the console app is run, it will perform your logic.
This is nice because if you need to run it again on the fly - just run the exe again :)
c) Third option is to have a SQL Job / SSIS that runs whenever the job is scheduled to run.
In the SSIS package, just use the script tasks to perform what you need to so.
Again, if you need to run it on the fly - simply run the SQL job!