Hello, I am quite new to asp.net mvc and am going to build a price comparison shopping site using mvc3. I will get shopping product feeds from a number of affiliate sites. I want to be able to download these feeds daily, at lets say 3.00am in the morning,
and when the downloading is finished to be able to add the feeds to my database. Obviously I want some automation in place and have read a few other threads about the subject, and understand that scheduled tasks would be the way to go. My question is, would
it be possible to add the downloaded feeds to my database and how would I go about doing that. The downloading part would be quite easy I think, just a couple of calls to a few built in classes, but I am a little unsure about how to hook up my database and
get it to update my tables. Any pointers would be much appreciated.
You can either write a windows service to do this, or a console application that you run with a scheduled task. In both cases it's just a .net program and you have to write the code to pull the data from different data sources and insert that data into your
database.
You can use any technology you like to add data to the database (Entity Framework, NHibernate , etc.)
summer4489
0 Points
1 Post
scheduled task with sql server
May 03, 2012 06:02 PM|LINK
Hello, I am quite new to asp.net mvc and am going to build a price comparison shopping site using mvc3. I will get shopping product feeds from a number of affiliate sites. I want to be able to download these feeds daily, at lets say 3.00am in the morning, and when the downloading is finished to be able to add the feeds to my database. Obviously I want some automation in place and have read a few other threads about the subject, and understand that scheduled tasks would be the way to go. My question is, would it be possible to add the downloaded feeds to my database and how would I go about doing that. The downloading part would be quite easy I think, just a couple of calls to a few built in classes, but I am a little unsure about how to hook up my database and get it to update my tables. Any pointers would be much appreciated.
CodeHobo
All-Star
18647 Points
2647 Posts
Re: scheduled task with sql server
May 03, 2012 08:00 PM|LINK
You can either write a windows service to do this, or a console application that you run with a scheduled task. In both cases it's just a .net program and you have to write the code to pull the data from different data sources and insert that data into your database.
You can use any technology you like to add data to the database (Entity Framework, NHibernate , etc.)
Blog | Twitter : @Hattan