Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: .NET Oracle SQL-Server-2008 , +
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.
Posted 28-Dec-11 5:31am
iamalik1.3K
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

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.
  Permalink  
Comments
thatraja at 28-Dec-11 11:00am
   
Right suggestion, Web app is better for this case. 5!
iamalik at 28-Dec-11 12:55pm
   
Thanks for your kind suggestions.
This application will also include picture capturing from WebCam and some scanner .Will web application help me in this regard ????
Espen Harlinn at 30-Dec-11 9:19am
   
5'ed!
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 2

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 Smile | :) ).
 
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!
  Permalink  
Comments
RaviRanjankr at 28-Dec-11 17:29pm
   
5+
Mika Wendelius at 28-Dec-11 17:33pm
   
Thanks Ravi :)
thatraja at 28-Dec-11 21:14pm
   
5!
Mika Wendelius at 29-Dec-11 0:43am
   
Thank you thatraja :)
iamalik at 29-Dec-11 0:36am
   
Thanks Mika
Mika Wendelius at 29-Dec-11 0:44am
   
You're welcome :)
Espen Harlinn at 30-Dec-11 9:20am
   
5'ed!
Mika Wendelius at 30-Dec-11 10:22am
   
Thanks :)

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

  Print Answers RSS
0 OriginalGriff 520
1 Maciej Los 290
2 Richard MacCutchan 265
3 BillWoodruff 265
4 Suraj Sahoo | Coding Passion 155
0 OriginalGriff 8,764
1 Sergey Alexandrovich Kryukov 7,437
2 DamithSL 5,639
3 Maciej Los 5,279
4 Manas Bhardwaj 4,986


Advertise | Privacy | Mobile
Web01 | 2.8.1411028.1 | Last Updated 28 Dec 2011
Copyright © CodeProject, 1999-2014
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