Need basic architecture for creating an application

Question

1.50/5 (2 votes)

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 asp.net which perform all the activities done by my previous tool so i need the basic architecture for developing this application in asp.net.

My observation :

1. If I Make it in asp.net(e.g 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.....

Thanks...
Jyotisankar

[Edit]Shouting removed[/Edit]

Posted 3-Dec-12 6:37am

JYOTISANKAR MOHAPATRA

Updated 3-Dec-12 17:44pm

v3

Add a Solution

Comments

Sergey Alexandrovich Kryukov 3-Dec-12 12:53pm

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.
--SA

JYOTISANKAR MOHAPATRA 4-Dec-12 5:31am

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 ...

Thanks

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

DaveCS · Answer 1 · 2012-12-03T17:59:00

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();
                      scr.WaitForExit();
                      ThumbnailCreate(ScreenShotFileName, ScreenShotThumbnailFileName, ThumbWidth, ThumbHeight, ThumbKeepAspectRatio);
                      //delete original file
                      File.Delete(ScreenShotFileName);
                      //return output;
                  }