需要用于创建应用程序的基本架构 [英] Need basic architecture for creating an application

问题描述

亲爱的所有人，



我有一个在MS Access中开发的工具，它在oracle数据库上进行多次批量更新，比如更新no。表以及从许多视图中检索数据。现在它工作得很好，整个周期更新过程需要30-40分钟。

现在我想在asp.net中开发一个应用程序，它执行我之前工具完成的所有活动，所以我需要在asp.net中开发这个应用程序的基本架构。



我的观察：



1.如果我在asp.net（例如网站）制作它可能会超时在更新过程中。



2.查询非常大，需要一段时间才能运行，因此我的会话将在网络中到期。



所以，任何人都可以建议我，我可以用C＃开发这个，所以我的所有要求都满足



我有一台服务器，我想在服务器和客户端PC中托管我的应用程序我想访问该应用程序。







需要你的想法.....



谢谢...

Jyotisankar



大喊大叫删除[/编辑]

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

Shouting removed[/Edit]

推荐答案

我会创建一个控制台e应用程序并将其托管在VPS上进行处理。



控制台应用程序可以像当前应用程序一样运行，前提是您可以通过命令行发送所有信息。当控制台完成后，它会编写一个新的html报告或更新服务器端数据库的结果，并跟进推文（需要Twitter API）或已完成状态的电子邮件。



我使用了类似的方法，即使长时间运行的流程也能正常工作。



//在服务器上启动一个控制台应用程序

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;
                  }

这篇关于需要用于创建应用程序的基本架构的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！