Click here to Skip to main content
13,357,610 members (35,866 online)
Rate this:
Please Sign up or sign in to vote.
See more:
Dear All,

I have a tool developed in MS Access, that doing multiple bulk updation on oracle database like updating no. tables and also retrieving data from many views. now its working nicely & it takes upto 30-40min for a full cycle update process.
Now I want to develope an application in which perform all the activities done by my previous tool so i need the basic architecture for developing this application in

My observation :

1. If I Make it in website) then may be it will be timeout in the middle of the updation.

2. Queries are very big and it will take time to run so my session will expire in the network.

So , Can anybody suggest me , in which way i can develop this in C# so dat all my requirements will fullfill

I have a server and I want to host my application in server and in client PC i want to access that Application .

Need your ideas.....


[Edit]Shouting removed[/Edit]
Posted 3-Dec-12 7:37am
Updated 3-Dec-12 18:44pm
Even though you can expect some useful response, this is not quite a valid request. What do you expect, "here is the architecture for you"? And don't have any particular suggestions, but you can expect no more then some very general recommendations. Unfortunately, we don't have resources to develop architecture or to write whole articles on request. You could get way more effective help you if ask some questions on more specific concerns.
Hi... Actually I didn't mean for the Archetecture .. It was my language mistake ..
basically i need the idea about how i can able to make it possible and through which platform or in which technologies it can be done ... dats much was my requirement .. if you have some idea den plzz u can share with me ...


1 solution

Rate this: bad
Please Sign up or sign in to vote.

Solution 1

I would create a console application and host it on a VPS to do the processing.

The console application could run like your current application provided you can send all the information via command line. When the console is complete have it write a new html report or update a server side database with the results and follow up with a tweet (Twitter API required)or email of the completed status.

I've use a similar approach and it works fine even with long running processes.

//start a console app on the server

ProcessStartInfo info = new ProcessStartInfo(pathtoCONSOL.EXE, RunArguments);
                  info.UseShellExecute = false;
                  info.RedirectStandardInput = true;
                  info.RedirectStandardError = true;
                  info.RedirectStandardOutput = true;
                  info.CreateNoWindow = true;
                  //info.WorkingDirectory = CutyCaptWorkingDirectory;
                  using (Process scr = Process.Start(info))
                      //string output = scr.StandardOutput.ReadToEnd();
                      ThumbnailCreate(ScreenShotFileName, ScreenShotThumbnailFileName, ThumbWidth, ThumbHeight, ThumbKeepAspectRatio);
                      //delete original file
                      //return output;

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy |
Web04 | 2.8.180111.1 | Last Updated 3 Dec 2012
Copyright © CodeProject, 1999-2018
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100