应用架构建议 [英] Suggestion for Application Architecture

问题描述

我将使用.Net前端的应用程序.该应用程序将在我组织的不同分支中工作.每个分支机构都可以在隔离的环境中工作，并且可以与主分支机构协作.

请为应用程序和数据库提出一些可靠，可伸缩，安全和经济的体系结构.

预先感谢.

Hi,
I am going to work an application with front end in .Net. This application will work in different branches of my organization. Each branch can work in isolated environment as well as it can collaborate with main branch to.

Kindly suggest some reliable, scalable, secure and economical architecture for application and database as well.

Thanks in advance.

推荐答案

0)将SQL Server用于数据库.
1)以asp.net网页或Silverlight模块的形式创建您的应用.

编写需要部署的桌面应用程序会增加成本.一个网站可以同时被数百个用户访问，如果适当地对其进行了设计，它可以允许您使用任何可能需要的用途.

0) Use SQL Server for the database.
1) Create your app in the form of either a asp.net web page or a Silverlight module.

Writing desktop apps that require deployment adds to the cost. A web site can be accessed by hundreds of users simultaneously, and if deisgned appropriately, it can allow any kind of use that you might require.

我要问的第一个问题是什么工具，您所熟悉的环境，语言等.第二件事是要求.您是否需要访问本地(客户端)资源(磁盘，驱动程序等)或程序(Office interop等).

这两个应该缩小可能性.如果不需要客户端交互(或者非常简单)，则创建基于Web的应用程序将更易于维护和分发(好吧，每个人都有Web浏览器:)).

关于环境.正如JSOP所建议的，Silverlight和ASP.NET都很好且易于使用.如果您决定使用桌面应用程序，我个人会选择带有ClickOnce分发的WPF(因为这是内部应用程序).如果您不熟悉WPF，它有一个学习曲线，但另一方面，Forms却开始喘不过气来(再次个人观点).

然后是语言. C#是我的最爱.一个很好的理由是它被广泛采用，因此获得帮助很容易.同样，C#与VB.NET并没有太大区别，但是编程能力要大得多.如果没有特殊要求，使用C ++可能会过大.

最后是数据库.因此，我很可能会被解雇，但是Oracle比SQL Server具有更强大的功能和更好的可调整性.但是，学习曲线又要高一些，而获得Oracle的帮助要困难一些，所以我仍然会选择SQL Server.

因此，也许可以概括地说:选择知道如何使用或易于学习的工具，以及在出现问题时可以轻松获得帮助的工具.

祝你好运！

First question I''d ask is what tools, environments, languages etc you''re familiar with. The second thing are the requirements. Do you need access to local (client side) resources (disks, drivers etc) or programs (Office interop and so on).

Those two should narrow down the possibilities. If no client side interaction is needed (or it''s very light) creating a web based application is easier to maintain and to distribute (well, everyone has a web browser :)).

About the environment. As JSOP suggested both Silverlight and ASP.NET are good and simple to use. If you decide to go to desktop application, personally I would choose WPF with ClickOnce distribution (since this was an internal application). If you''re not familiar with WPF, it has a learning curve but on the other hand Forms is starting to take it''s last breath (again personal opinion).

And then the languages. C# would be my favourite. One good reason is that it''s widely adopted so getting help is easy. Also C# isn''t that much different from for example VB.NET but the programming power is far greater. Using C++ would perhaps be an overkill if no special requirements exist.

And lastly the database. Most likely I''m going to be flamed because of this but Oracle is more capable and adjustable than SQL Server. But, again the learning curve is higher and getting help with Oracle is a bit more difficult so I would still choose SQL Server.

So perhaps in a nutshell: Select tools you know how to use or that are easy enough to learn and tools that you can get easily help with if questions arise.

Good luck!

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